menphee Wrote:
i know this must be simple.....but......im referencing one sheet to
another....example on sheet 2 =(sheet1!a1) ...i want the cell to be
blank on
sheet 2 unless there is information on sheet 1......i know this isn't
brain
surgery...but ive tried all the cell formats and nothing seems to
return a
blank on sheet 2....HELP
Thanx, Mike

Hi Mike

This should work for you

If(Sheet1!A1="","",Sheet1!A1), It's saying if Sheet1 Cell A1 is balnk,
return a blank, otherwise return what is in Sheet 1 cell A1


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399692