If Formula

Closed
Azhar - Jan 24, 2011 at 01:16 AM
venkat1926 Posts 1864 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

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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,"")))))
0