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


See More: I need the =IF formular as below

Reply ↓  Report •

August 19, 2016 at 07:16:16
Never mind i solved it as follows:


Thank you any way.

Reply ↓  Report •

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:


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

Reply ↓  Report •

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 = 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