What's wrong with this formula?

[Ray]

=IF(B27>0,+B27:B32-B28,"")
Want to add B27-B32 and subtract B28 if B27 is >0.
If not I want the cell to stay blank.
As soon as I enter a number in B27 the cell shows ###.
The cell is wide enough and the cell format is general.
Working only with numbers
Thanks

 

[Pete_UK]

Did you check out your earlier post to see if there are any answers
there?

Pete

 

[Luke M]

As pointed out in your earlier thread
http://www.microsoft.com/office/com...&p=1&tid=e004f23d-47b2-4d86-b360-02cd45391cb5

You cannot simply stick an array of cells in the formula. I think you want:
=IF(B27>0,SUM(B27:B32)-B28,"")

 

[Glenn]

=IF(B27>0,+B27:B32-B28,"")
Want to add B27-B32 and subtract B28 if B27 is >0.
If not I want the cell to stay blank.
As soon as I enter a number in B27 the cell shows ###.
The cell is wide enough and the cell format is general.
Working only with numbers
Thanks

Do you mean this:


=IF(B27>0,SUM(B27:B32)-B28,"")