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!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.