Show Blank Cell That References Another cell

[Mooseman60]

Hi

Trying to get a cell I14 that has a formula that gives a calculation based on data in cell D35*D36 to show blank until a number is entered in cell B14

Basically in cell D35 is the number 74, I14 multiplies this number by data in D36 (=D35*D36)

Hope this makes sense

Thanks Craig

 

[Velven]

Hello Craig

Enter this formula at I14 :-

=IF(B14<>"",(D35*D36),"")

Wen

 

[Mooseman60]

Hello Craig

Enter this formula at I14 :-

=IF(B14<>"",(D35*D36),"")

Wen

Hi Wen

That works great but now i get Value in L14 which has this formula in it =(H14*I14)+(B14*J14)

 

[Velven]

That works great but now i get Value in L14 which has this formula in it =(H14*I14)+(B14*J14)

What do you mean by this ?

Perhaps you can post a small table to show an example on what you want.

 

[Mooseman60]

Wen how do i attach a file

 

[Velven]

Don't think you can attach it here. What I do is copy paste from Excel example.

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Sample[/TD]
[TD="align: center"]Sample[/TD]
[TD="align: center"]Sample[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Sorry , I'm not a veteran here. Or they use Mrexcel plugin

 

[Mooseman60]

Do you have an email address i can send a copy of my file to

[TABLE="width: 1286"]
<colgroup><col><col><col><col><col span="5"><col><col><col><col span="6"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]