Help on IF statement?

scobad

Board Regular
Joined
Feb 7, 2005
Messages
164
=IF(O2>10,40,IF(O2=4,16,IF(O2=5,20,IF(O2=6,24,IF(O2=7,28,IF(O2=8,32,IF(O2=9,36,)))))))

What is happening is that if the O2 is 6 it is returning zero?

4=16
5=20
6=24
7=28
8=32
9=36

10,11,12 = 40
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
L

Legacy 51064

Guest
Andrew has a very nice solution. If you need all of the if statements:

=IF(O2=4,16,IF(O2=5,20,IF(O2=6,24,IF(O2=7,28,IF(O2=8,32,IF(O2=9,36,IF(O2>10,40,0)))))))


Will O2 ever be less than 4?
 
L

Legacy 51064

Guest
If the product is not a whole number, then the my solution will not help you in its current form.
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Clearly the result of

=(M2-I2)/30

isn't exactly 6

You perhaps need to adjust one of the formulas, either you round the value in O2 to the nearest integer

=ROUND((M2-I2)/30,0)

or perhaps adjust the other formula to cope with values that are not integers
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,086
Members
412,310
Latest member
mark884
Top