Hiding Formulas
 

Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

hi
Try it this way =IF(A1="","",A1+2) that will give you a blank cell, if you want
0, change the "" for 0
HTH
John
"Looking for help today" <Looking for help
wrote in message ...
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

Try this:

=IF('Sheet1'!A1="","",'Sheet1'!A1+2)

HTH
Elkar


"Looking for help today" wrote:

Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

One of these should work for you
=IF(ISBLANK('Sheet1'!A1), "",'Sheet1'!A1+2)
=IF(ISBLANK('Sheet1'!A1), 0,'Sheet1'!A1+2)
=IF('Sheet1'!A1= "" , "",'Sheet1'!A1+2)
=IF('Sheet1'!A1= "" , 0,'Sheet1'!A1+2)
=('Sheet1'!A1< "")*('Sheet1'!A1+2)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Looking for help today" <Looking for help
wrote in message ...
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell
as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able
to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

OOPS forgot the sheet name: =IF('Sheet1'!A1="","",'Sheet1'!A1+2) same formula.
Regards
John
"John" wrote in message
...
hi
Try it this way =IF(A1="","",A1+2) that will give you a blank cell, if you
want 0, change the "" for 0
HTH
John
"Looking for help today" <Looking for help
wrote in message ...
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

This worked great. AWESOME! Did just what I needed and will save me about 30
minutes each day at work. Thanks for your help

"John" wrote:

OOPS forgot the sheet name: =IF('Sheet1'!A1="","",'Sheet1'!A1+2) same formula.
Regards
John
"John" wrote in message
...
hi
Try it this way =IF(A1="","",A1+2) that will give you a blank cell, if you
want 0, change the "" for 0
HTH
John
"Looking for help today" <Looking for help
wrote in message ...
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

Thanks for your help. This works great. I really appreciate it.

"Elkar" wrote:

Try this:

=IF('Sheet1'!A1="","",'Sheet1'!A1+2)

HTH
Elkar


"Looking for help today" wrote:

Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

Worked great. Thanks for your help. First time I ever used this site for help
and boy, will I be back again when I need to. Again, thank you.

"Bernard Liengme" wrote:

One of these should work for you
=IF(ISBLANK('Sheet1'!A1), "",'Sheet1'!A1+2)
=IF(ISBLANK('Sheet1'!A1), 0,'Sheet1'!A1+2)
=IF('Sheet1'!A1= "" , "",'Sheet1'!A1+2)
=IF('Sheet1'!A1= "" , 0,'Sheet1'!A1+2)
=('Sheet1'!A1< "")*('Sheet1'!A1+2)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Looking for help today" <Looking for help
wrote in message ...
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell
as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able
to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

You're welcome
John
"Looking for help today" wrote
in message ...
This worked great. AWESOME! Did just what I needed and will save me about 30
minutes each day at work. Thanks for your help

"John" wrote:

OOPS forgot the sheet name: =IF('Sheet1'!A1="","",'Sheet1'!A1+2) same
formula.
Regards
John
"John" wrote in message
...
hi
Try it this way =IF(A1="","",A1+2) that will give you a blank cell, if you
want 0, change the "" for 0
HTH
John
"Looking for help today" <Looking for help
wrote in message ...
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell
as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able
to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.

Hiding Formulas
 

=IF('Sheet1'!A1="","",'Sheet1'!A1+2)
--
David Biddulph

"Looking for help today" <Looking for help
wrote in message ...
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell
as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able
to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.