=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.