Perhaps you had the cell format set to Text? Format the cell as General &
re-enter the formula.
--
David Biddulph

"Sher" wrote in message
...
Hello Max -

I typed in the "IF" Statement but for some reason the statement just
showed
up on both sheets; so instead of making it blank it just place the
statement
there.

"Max" wrote:

Use something like this in say, Sheet1's A2:
=IF(Sheet2!B2="","",Sheet2!B2)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"Sher" wrote:
Hello -

I need to create an "F" Statement that on one sheet I have spend plan
and on
the another sheet I have an ad hoc sheet. I would like a statement
that
states if a field is blank on ad hoc than it is blank on spend plan.
Right
now when I delete a field on the ad hoc it puts Jan 1900 on the spend
plan
field.

Any help would be appreciated.

Thank you,