Snake Eyes
Board Regular
- Joined
- Dec 14, 2010
- Messages
- 103
- Office Version
- 365
- 2016
- Platform
- Windows
Greetings,
I'm not quite sure why I can't figure this out...
F13 = 7
O13 = 435
X9 = 22%
This formula returns a blank cell in T13 as expected:
Then this formula gets me the #VALUE! error where I would expect a 0:
I'm not quite sure why I can't figure this out...
F13 = 7
O13 = 435
X9 = 22%
This formula returns a blank cell in T13 as expected:
Excel Formula:
=IF(F13<365,"",O13)
Then this formula gets me the #VALUE! error where I would expect a 0:
Excel Formula:
=(T13*$X$9)