Thread: how to get excel to display blank if reference cell blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default how to get excel to display blank if reference cell blank
=IF(Sheet1!A1="","",Sheet1!A1*250)

as an example


--

Regards,

Peo Sjoblom


"silent1 (not)" wrote in message
...
I'm trying to get a blank if a refernce cell is blank or perform
calculation
using the reference cell if there is an entry in the ref cell


Reply With QuoteReply With Quote