willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 871
- Office Version
- 365
- Platform
- Windows
I have the below formula that I am missing something and cannot think of what:
If N2 is 0, leave blank
If S2 is 0: N2-I2 then subtract W2 (only if it is not blank)
If S2 is greater than N2: N2-S2 then subtract W2 (only if it is not blank)
Any help would be appreciated.
Thank you
Code:
=IF(N2=0,"",IF(S2="0",(N2-I2-(W2*(W2<>""),IF(S2>N2,(N2-S2-(W2*(W2<>""))))
If N2 is 0, leave blank
If S2 is 0: N2-I2 then subtract W2 (only if it is not blank)
If S2 is greater than N2: N2-S2 then subtract W2 (only if it is not blank)
Any help would be appreciated.
Thank you