excellenfant
New Member
- Joined
- Nov 23, 2016
- Messages
- 8
Hello,
I have an if formula, if('sheetA'!D7<0,abs('sheetA'!D7),0). The value in the criterion cell is substantially lower than 0. Nevertheless, the if formula doesn't return the absolute value. No error code shows. The formula does not show as text. Just in case, I checked the formats anyway.
This is part of a pro forma model for class with an automatic drawdown on a revolver. I have automatic calculations enabled, as well as iterative calculations (up to 100).
Any thoughts?
I have an if formula, if('sheetA'!D7<0,abs('sheetA'!D7),0). The value in the criterion cell is substantially lower than 0. Nevertheless, the if formula doesn't return the absolute value. No error code shows. The formula does not show as text. Just in case, I checked the formats anyway.
This is part of a pro forma model for class with an automatic drawdown on a revolver. I have automatic calculations enabled, as well as iterative calculations (up to 100).
Any thoughts?