View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
AnotherNewGuy AnotherNewGuy is offline
external usenet poster
 
Posts: 44
Default Cell to return blank not 0

Just a quick thanks for that explanation. I was reading these thinking that
the first parameter doesn't return a logical value. Turns out I was wrong.

"Shane Devenshire" wrote:

Hi,

Try =IF(SUM(B4:B13),SUM(B4:B13),"")

This works because if SUM(B4:B13) returns 0 Excel considers it FALSE, for
any other number Excel considers it TRUE.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Darts via OfficeKB.com" wrote:

In cell b14 this is my formula - if these cells are blank i want the return
to be blank it is giving me a return of 0
=if(sum(b4:B13),"",sum(b4:B13))

--
Message posted via http://www.officekb.com