I'm puzzled

[Sonars_UK]

Hi,

I have a spreadsheet which records my small business's accounts. I've
recorded all accounts year to date and I continue past the current date with
entries to give me a forecast to the year end (I hope that bit made sense).

The most important column is 'Balance at Bank'. I have the following
formula in the column to give me a running bank balance:
=IF(OR(F136<>"",G136<>""),H135+G136-F136,"")

For some reason that I can not fathom I am getting a #VALUE! error message
half way down the column. I have no idea what is going wrong. I've checked
the formula in cells that are working properly and everything appears to be
the same in the cells I am having problems with.

I'm a relative newbie and am at a loss. I suppose that this post may be a
little vague but would dearly appreciate any advice given.

Regards,

Sonars UK

 

[JE McGimpsey]

You probably used the space bar to "delete" a value. That inserts a
space character in the cell, which is text. The + operator returns a
#VALUE! error if its operands are text.

Obviously you can find and delete the space character to fix the problem.

You can also revise your formula to use function(s) which ignore text,
like SUM():

=IF(COUNT(F136:G136)>0,SUM(H135,F136:G136),"")

 

[Arvi Laanemets]

Hi

=IF(COUNT(F136:G136)>0,SUM(H135,F136,-G136),"")
is a way better solution )

 

[JE McGimpsey]

Yup, missed the - sign in the original. Thanks.