SOLVED

If statement

Brass Contributor

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

1 Reply
best response confirmed by Xeryar (Brass Contributor)
Solution
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 best response

Accepted Solutions
best response confirmed by Xeryar (Brass Contributor)
Solution
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.

View solution in original post