Prev: Solver
Next: Drop Down with hidden values
From: DavidS on 7 Jun 2010 13:17
I have a reference to a cell in another worksheet, same workbook. When the
value in the referenced cell is blank it returns a "0" value. However, I want
the returned value to simply leave as a blank cell. Any advice?
David
From: John on 7 Jun 2010 14:02
Hi David
Something like this : =IF(Sheet1!A1="","",Sheet1!A1)
HTH
John
"DavidS" <DavidS(a)discussions.microsoft.com> wrote in message
news:71737C7E-5095-4E27-A70C-82CE3845C368(a)microsoft.com...
>I have a reference to a cell in another worksheet, same workbook. When the
> value in the referenced cell is blank it returns a "0" value. However, I want
> the returned value to simply leave as a blank cell. Any advice?
> David

 | 
Pages: 1
Prev: Solver
Next: Drop Down with hidden values