Hiding Formulas

[Looking for help today]

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.

 

[John]

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

 

[Elkar]

Try this:

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

HTH
Elkar

 

[Bernard Liengme]

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)

 

[John]

OOPS forgot the sheet name: =IF('Sheet1'!A1="","",'Sheet1'!A1+2) same formula.
Regards
John

 

[Looking for help today]

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

 

[Looking for help today]

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

 

[Looking for help today]

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.

 

[John]

You're welcome
John

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

 

[David Biddulph]

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