Hello,
I have a weird problem (but probably simple to you) - The spreadsheet is attached. Version is Excel 2013 and I'm running Win7.
I've been using this budget for years with the exact same formulas and then all of a sudden last night, I started getting an error of #VALUE.
Example
B(15) C(15) D(15)
Budget Actual Cost Difference
(160.00) (167.59) 7.59 Formula is =C15-B15
How I enter -160 - 167.59
B & C are formatted as Number, 2 decimal, Symbol None, use 1000 Separator, Negative is (1,234.10) in black
I've also tried it as B&C as currency.
D is formatted as Accounting, Decimal 2, Symbol None
Note that the ones with middle values had no errors, that's what it did until the other day.
The ones on the right in yellow, you will see 2 highlighted.
On the first one - When I enter the C15 as -65.00, D15 gives me a #VALUE
So then I tried entering it without the - on the next row and D15 ADDS!!!!!!!
Can someone please help? Thank you so much in advance
Bookmarks