peterderrington
New Member
- Joined
- Aug 6, 2019
- Messages
- 26
- Office Version
- 2019
- Platform
- Windows
Hi,
I have a sheet that calculates length of stay, all fairly easy, just subtract column D from Column AE.
The problem i have is that if the answer returns 0 (they arrived and left on the same day) i want it to return 1.
The current formula looks like this and displays nothing at all if either field is blank - i need to retain that feature:
=IF(OR(ISBLANK(D5),ISBLANK(AE5)),"",AE5-D5)
My gut says that a SUMIFS formula could help me here but i'm tying myself up in knots.
Can anyone help?
Thanks
I have a sheet that calculates length of stay, all fairly easy, just subtract column D from Column AE.
The problem i have is that if the answer returns 0 (they arrived and left on the same day) i want it to return 1.
The current formula looks like this and displays nothing at all if either field is blank - i need to retain that feature:
=IF(OR(ISBLANK(D5),ISBLANK(AE5)),"",AE5-D5)
My gut says that a SUMIFS formula could help me here but i'm tying myself up in knots.
Can anyone help?
Thanks