If statements

[Solved/Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
use this formula in an empty cell

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month