Forum Discussion
GBarbs96
Mar 29, 2024Copper Contributor
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...
HansVogelaar
Mar 29, 2024MVP
=IF(B43<10, 2, IF(B43<20, 1, IF(B3<40, 0, "")))