ncjefffl
New Member
- Joined
- May 5, 2010
- Messages
- 22
I'm getting a weirdness using the following formula (which uses labels):
=IF(ParOtc="PAR",SUM(NegNetBenAmt+POSNetBenAmt),Referral Amt)
NegNetBenAmt,PosNetBenAmt,Referral Amt and the cell in which the formula lives are all formatted the same (Accounting, 2 decimals). In some cells (same column) it works and in some I get the #VALUE! error. However, all I have to do is hit F2 and the #VALUE! error goes away and the correct number appears. I can live with the mystery if I must, but it's annoying to have to F2 my way down a column when there are dozens of cells to fix.
I've tried going into Options, Calculations and hitting "Calc Sheet" or "Calc Now(F9)" and nothing happens. Calculation is set to Automatic, Iteration is unchecked and under workbook options all are checked except Precision as displayed and 1904 date system.
Thanks!
=IF(ParOtc="PAR",SUM(NegNetBenAmt+POSNetBenAmt),Referral Amt)
NegNetBenAmt,PosNetBenAmt,Referral Amt and the cell in which the formula lives are all formatted the same (Accounting, 2 decimals). In some cells (same column) it works and in some I get the #VALUE! error. However, all I have to do is hit F2 and the #VALUE! error goes away and the correct number appears. I can live with the mystery if I must, but it's annoying to have to F2 my way down a column when there are dozens of cells to fix.
I've tried going into Options, Calculations and hitting "Calc Sheet" or "Calc Now(F9)" and nothing happens. Calculation is set to Automatic, Iteration is unchecked and under workbook options all are checked except Precision as displayed and 1904 date system.
Thanks!