Mar 29 2024 01:53 PM
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?
Mar 29 2024 02:08 PM
=IF(B43<10, 2, IF(B43<20, 1, IF(B3<40, 0, "")))