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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 28, 2011 at 09:25 PM
Related:
- If statements
- How many if statements can you nest - Guide
- Excel if statement with text - Guide
- Excel if statements with dates - Guide
- Remove false from if statement ✓ - Office Software Forum
- If-Else statement in C# ✓ - Programming Forum
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
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,""))
=IF(AND(B5<150000,B5>0),52,IF(B5=0,0,""))
