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.