What's wrong with this formula?
 

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

What's wrong with this formula?
 

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

regards
FSt1

"Ray" wrote:

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

What's wrong with this formula?
 

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

If so, try this:

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

Hope this helps.

Pete

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

What's wrong with this formula?
 

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(b270,b27-b28,"")
or,
=if(b270,b27-b32-b28,"")
?

Regards,
Fred

"Ray" wrote in message
...
=IF(B270,+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

What's wrong with this formula?
 

That worked!!
Thank you very much!!

"Pete_UK" wrote:

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

If so, try this:

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

Hope this helps.

Pete

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

.

What's wrong with this formula?
 

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

Pete

On Feb 16, 8:24*pm, Ray wrote:
That worked!!
Thank you very much!!



"Pete_UK" wrote:
Are you trying to add the numbers B27 to B32, omitting B28 ?

If so, try this:

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

Hope this helps.

Pete

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

.- Hide quoted text -

- Show quoted text -