Forum Discussion
Solved
If statement
I am confused about an if state . My scenario is such
If B7<365 In warranty
If B7>365 Out of warranty
is b7 is blank then the cell stays blank .
Can someone please assist
- try this
=IFS(B7="","",B7<365,"In warranty",B7>365,"Out of warranty")
Of course, this doesn't know what to do if B7 = 365. I think you want to make one of those latter two statements <= or >=, whichever is the accurate state of coverage.
1 Reply
- try this
=IFS(B7="","",B7<365,"In warranty",B7>365,"Out of warranty")
Of course, this doesn't know what to do if B7 = 365. I think you want to make one of those latter two statements <= or >=, whichever is the accurate state of coverage.