Can any one work out the following in Excell as i cannot get the fomular. =IFA3<15 = 10

=IFA3>15 but <30 =15

=IFA3>30 but <60 = 20

=IFA3>60 but <100 =25

=IFA3>100 =30Thanks

Never mind i solved it as follows: =IF(A3<15,10*A3,IF(A3<35,12*A3,IF(A3<55,14*A3,IF(A3<80,16*A3,IF(A3<100,16*A3,IF(A3>100,18*A3))))))

Thank you any way.

in fact i was getting a FALSE each time A3 was 100, so i revised the formular to: =IF(A3<15,10*A3,IF(A3<35,12*A3,IF(A3<55,14*A3,IF(A3<80,16*A3,IF(A3<100,16*A3,IF(A3>98,18*A3))))))

This works as it encompases the below 100 ad above 100 to include 100 itself.

Of course, none of your solutions match your requirements as posted in your original question. In any case, you have a problem with your last 2 clauses:

IF(A3<100,16*A3,IF(A3>98,18*A3)

If A3 = 99 the formula will return 16*A3 since 99 is less than 100. Your last clause IF(A3>98,18*A3) will never be evaluated. I guess that's a good thing because you can't expect Excel to return 2 different results from the same input.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Ask Your Question

Weekly Poll