If statements

Solved/Closed
oshngzr - Nov 28, 2011 at 02:50 PM
venkat1926 Posts 1863 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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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