If Formula

Closed

Azhar - Jan 24, 2011 at 01:16 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 24, 2011 at 10:39 PM

I want to have IF function working for me to carry out following condition

Clients Salary
0-7 Zero
8-14 3000
15-20 6000
21-30 9000
>30 12000

Also want to have a color formatting linked with above results.

I am finding it difficult to construct this formula. Any Help Plz

Azhar

If Formula
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Credit summation formula - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 24, 2011 at 10:39 PM

suppose you enter client number in A2 the
in B2 tyhpe or copy this formula

=IF(AND(A2>=0,A2<=7),0,IF(AND(A2>7,A2<=14),3000,IF(AND(A2>14,A2<=20),6000,IF(AND(A2>20,A2<=30),9000,IF(A2>30,12000,"")))))

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!