Solved I need the =IF formular as below

August 19, 2016 at 07:09:16
Specs: Windows 64
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 =30

Thanks


See More: I need the =IF formular as below

Reply ↓  Report •


#1
August 19, 2016 at 07:16:16
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.


Reply ↓  Report •

#2
August 19, 2016 at 07:30:15
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.


Reply ↓  Report •

#3
August 19, 2016 at 08:30:48
✔ Best Answer
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


Reply ↓  Report •

Related Solutions


Ask Question