Calculations using empty cells

[Hank in KC]

I have a spreadsheet with three columns: Current balance, withdrawals, and
deposits. Current balance is determined by subtracting withdrawals and
adding deposits to the balance in the line above.

Suddenly I have started getting a cell entry
#VALUE!

in the current balance cell.

A typical entry in the cell is for G43 would be:

=G42-E43+F43 and the sudden new result is #VALUE.

All three columns have cells formatted as numbers.

HELP!

 

[fredg]

I have a spreadsheet with three columns: Current balance, withdrawals, and
deposits. Current balance is determined by subtracting withdrawals and
adding deposits to the balance in the line above.

Suddenly I have started getting a cell entry
#VALUE!

in the current balance cell.

A typical entry in the cell is for G43 would be:

=G42-E43+F43 and the sudden new result is #VALUE.

All three columns have cells formatted as numbers.

HELP!

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.

 

[rpw]

What fredg said plus: Check the contents of the cells - you will get that
#VALUE! when trying to add a 'space' to numbers. You won't see the space but
someone hit the space bar while in that cell [or your formula says something
like if(A3=0,"",A4)] - the "" is a blank space character and cannot be added
to other numbers.)