IF formula which returns something only if cell is populated

[lzweifel]

Hi again,

I cannot figure out my formula this morning to deliver a formula only if a cell is populated...


If I put a figure in Cell A1, then Cell B1 would deliver the value of 30.00 and Cell C1 the value of A1*B1 = 330.00 IF however cell A1 is left blank then all three cells would remain blank.

Thanks in advance

 

[63falcondude]

Maybe something like this?

B1=IF(A1="","",30)
C1=IF(A1="","",A1*B1)

Note that C1 would only be 330 if you entered 11 in A1.

 

[Norie]

In B1,

=IF(A1="", "", 30)

and in C1.

=IF(A1="", "", A1*B1)