Forum Discussion
Excel IF/AND/OR/NOT Functions
Hi guys,
I need some help in writing a formula.
basically, in cell G43, i wanna say if cell B43 is less than 40 to display the number 0, if B43 is less than 20 to display the number 1 or if B43 is less than 10 to display the number 2.
is it possible to get this all into one formula?
=IF(B43<10, 2, IF(B43<20, 1, IF(B3<40, 0, "")))
