Prev: Locked Cells
Next: How to give find function ( same as of ctrl F) in formula bar
From: Paul Peterson - Velox Consulting, LLC on 26 Apr 2010 17:10
I have a simple formula that inserts a value in a cell from one spreadsheet
into the cell of another spreadsheet. If the source cell doesn't have a
value, the destination cell has a zero in the cell. I would like to display
a blank if the source cell doesn't contain a value - any ideas?

Paul C. Peterson
From: Jim Thomlinson on 26 Apr 2010 17:20
=if(a1 = "", "", a1)
--
HTH...

Jim Thomlinson


"Paul Peterson - Velox Consulting, LLC" wrote:

> I have a simple formula that inserts a value in a cell from one spreadsheet
> into the cell of another spreadsheet. If the source cell doesn't have a
> value, the destination cell has a zero in the cell. I would like to display
> a blank if the source cell doesn't contain a value - any ideas?
>
> Paul C. Peterson
From: Chip Pearson on 26 Apr 2010 17:30

Instead of something like

=Sheet1!A1

use

=IF(Sheet1!A1="","",Sheet1!A1)

This says that if Sheet1!A1 is empty, return an empty string;
otherwise, return Sheet1!A1.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Mon, 26 Apr 2010 14:10:01 -0700, Paul Peterson - Velox Consulting,
LLC <PaulPetersonVeloxConsultingLLC(a)discussions.microsoft.com> wrote:

>I have a simple formula that inserts a value in a cell from one spreadsheet
>into the cell of another spreadsheet. If the source cell doesn't have a
>value, the destination cell has a zero in the cell. I would like to display
>a blank if the source cell doesn't contain a value - any ideas?
>
>Paul C. Peterson
 | 
Pages: 1
Prev: Locked Cells
Next: How to give find function ( same as of ctrl F) in formula bar