PDA

View Full Version : Solved: formula problem, nested if


CatDaddy
06-23-2011, 01:33 PM
=IF(P31<10,7,IF(P31>10 AND P31<20,6,IF(P31>20 AND P31<30,5, IF(P31>30 AND P31<40,4, IF(P31>40 AND P31<50, 3, IF(P31>50 AND P31<60, 2, 1))))))

says it contains an error...
Bob Phillips
06-23-2011, 01:38 PM
And it does contain an error.

ANDs are used like so

AND(Cond1, cond2)

not like

cond1 AND cond2
CatDaddy
06-23-2011, 01:47 PM
And it does contain an error.

ANDs are used like so

AND(Cond1, cond2)

not like

cond1 AND cond2

durrr....too much time in c++

by which i mean thank you of course!