Show Blank Cell That References Another cell

Mooseman60

New Member
Joined
Sep 30, 2010
Messages
49
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
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Velven

New Member
Joined
Nov 30, 2017
Messages
37
Hello Craig

Enter this formula at I14 :-

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

Wen
 
Last edited:

Velven

New Member
Joined
Nov 30, 2017
Messages
37
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.
 
Last edited:

Mooseman60

New Member
Joined
Sep 30, 2010
Messages
49

ADVERTISEMENT

Wen how do i attach a file
 

Velven

New Member
Joined
Nov 30, 2017
Messages
37
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>
ABC
1SampleSampleSample
2
3

<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>


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

Mooseman60

New Member
Joined
Sep 30, 2010
Messages
49
Do you have an email address i can send a copy of my file to


<colgroup><col><col><col><col><col span="5"><col><col><col><col span="6"></colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,512
Members
409,583
Latest member
RedHelp

This Week's Hot Topics

Top