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.
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.
=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.