Excel IF/AND/OR/NOT Functions

Copper Contributor

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?

1 Reply

@GBarbs96 

=IF(B43<10, 2, IF(B43<20, 1, IF(B3<40, 0, "")))