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...
=IF(B43<10, 2, IF(B43<20, 1, IF(B3<40, 0, "")))