Formula not adding minus figures

[Donal28]

Hi All

I'm havng a really strange problem with what seems a simple formulas works in one spreadsheet but not the other!! the formula simply adds 2 numbers together in Cell N10

=IF(N8="","",SUM(N8:N9))

However when the same for is used in another spreadsheet and the N9 cell is a minus figure e.g. -1 then the N10 cell just goes blank. There is no conditional formatting in the cell N10 and the formatting is set to minus number with 0 decimal places so I cannot figure out what is going on!!!

Any help on this would be very much apprecaited


Regards
Donal

 

[Kaps_mr2]

are you sure that the cell is formatted to a number rather than text ? Thanks

Regards

Kaps

 

[Donal28]

Yes its definitely formatted to a number

 

[barry houdini]

If this formula returns a blank

=IF(N8="","",SUM(N8:N9))

...then I assume that N8 is blank

 

[Donal28]

yes thats right N8 is blank but I just want the formula to add N8:N9 even if one of the the cells is blank

 

[barry houdini]

The formula you are using is explicitly returning a blank if N8 is blank - if you just want the SUM try simply

=SUM(N8:N9)

or if you want a blank only when neither cell contains a number try

=IF(COUNT(N8:N9),SUM(N8:N9),"")

 

[Donal28]

The formula you are using is explicitly returning a blank if N8 is blank - if you just want the SUM try simply

=SUM(N8:N9)

or if you want a blank only when neither cell contains a number try

=IF(COUNT(N8:N9),SUM(N8:N9),"")

Yes thats worked fine, thanks for your help