Linking Cells between worksheet

1q2w3

New Member
Joined
Mar 20, 2020
Messages
22
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I have a problem with linking a cell between two worksheet with some formulas involved.

On Sheet 3, I have a formula in D4 that is dependent on the result in C4.
1585912883509.png

Before linking the B3 cell from another worksheet 'Sheet 2', the formula works fine when I manually input numbers into C4.

However, when I tried to link B3 cell from 'Sheet 2' to the C4 cell in 'Sheet 3', this is when the problem comes in.
1585913031710.png


Cell D4 no longer able to show 'pending' anymore if B3 cell is blank. It automatically show up as failed.
1585913074018.png


How can I fix this? So If my B3 cell in 'Sheet 2' is empty, I want C4 in 'Sheet 3' to remain empty rather than automatically filling that with the invisible 0.

Thanks all
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,844
Office Version
  1. 365
Platform
  1. Windows
If you look at the formula you posted, you are linking cell B3 from Sheet3, not Sheet2.
Perhaps that is your issue, maybe you typed in the wrong sheet number in your formula?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,903
Messages
5,544,964
Members
410,645
Latest member
aroesch
Top