SOLVED

If statement

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