What's wrong with this formula?

  • Thread starter Thread starter Ray
  • Start date Start date
R

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
 
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
 
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
 
That worked!!
Thank you very much!!

Pete_UK said:
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



.
Click to expand...
 
Back
Top