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