What's wrong with this formula?

[Ray]

=IF(B27>0,+B27:B32-B28,"")
Working with numbers only. If false I want the cell to be blank.
I'm getting ####
Doesn't help to widen cell
format of cell is general
Thanks

 

[FSt1]

hi
try
=(B27>0,sum(B27:B32)-B28,"")

regards
FSt1

 

[Pete_UK]

Are you trying to add the numbers B27 to B32, omitting B28 ?

If so, try this:

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

Hope this helps.

Pete

 

[Fred Smith]

It would help if you told us what you want to accomplish.

You cannot use the range B27:B32 that way. Do you perhaps want:
=if(b27>0,b27-b28,"")
or,
=if(b27>0,b27-b32-b28,"")
?

Regards,
Fred

 

[Ray]

That worked!!
Thank you very much!!

Are you trying to add the numbers B27 to B32, omitting B28 ?

If so, try this:

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

Hope this helps.

Pete



.

 

[Pete_UK]

You're welcome, Ray, but please don't multi-post.

Pete