View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
waybomb waybomb is offline
external usenet poster
 
Posts: 10
Default How to return a blank formula cell if the reference is blank?

Hi All

Let's say I have a formula in cell c1. It references a number input into
cell a1, and does some math with that cell and a fixed number in cell b1.

Now what I want to do is have cell c1 be blank if cell a1 is also blank. But
when a number is entered into cell a1, I want the resultant formula answer to
be displayed in cell c1.

What do I add to my formula to do so, and where do I put it?

Thanks - y'all are a big help!