View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RaY RaY is offline
external usenet poster
 
Posts: 164
Default 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