Thread: Making formula results not visible in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Making formula results not visible in a cell
=IF(A101="","",SUM(B1:B100))
--
David Biddulph

"mp smith" wrote in message
...
In my "total" column I don't want the results of the SUM to show up if
there
is not an entry in the cell to the left of the SUM cell.
--
MPS


Reply With QuoteReply With Quote