If statements

Solved/Closed
oshngzr - Nov 28, 2011 at 02:50 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Nov 28, 2011 at 09:25 PM
Hello,

I'm trying to create an "if statement" that will allow for the following scenario:

B5 <=150,000 but greater than 0 value returned =52, if B5=0 value returned=0

Regards

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Nov 28, 2011 at 09:25 PM
use this formula in an empty cell

=IF(AND(B5<150000,B5>0),52,IF(B5=0,0,""))
1