What's wrong with this formula?
 

=IF(B270,+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

What's wrong with this formula?
 

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

Pete

On Feb 16, 8:00*pm, Ray wrote:
=IF(B270,+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

What's wrong with this formula?
 

As pointed out in your earlier thread:
http://www.microsoft.com/office/comm...0-02cd45391cb5

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ray" wrote:

=IF(B270,+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

What's wrong with this formula?
 

Ray wrote:
=IF(B270,+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(B270,SUM(B27:B32)-B28,"")