What's wrong with this formula?

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

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
 
Ray said:
=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
Click to expand...

Do you mean this:


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