Thread: Trying to Get a Blank Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] l.clarkson@hotmail.co.uk is offline
external usenet poster
  
Posts: 1
Default Trying to Get a Blank Cell

Hi

I am trying to make a cell back if a formula doesn't add up

I am using the formula below, can anyone tell me where i am going
wrong as this doesn;t work


=IF(ISNA(SUM(C9+E9)/6),"",SUM(C9+E9)/6)

Many Thanks

Lins
Reply With QuoteReply With Quote