Sounds like the cell that you placed the formula in was earlier formatted as
TEXT (unknown to you). Try formatting* that formula cell to either General or
Number first, then click inside the formula bar and press ENTER to re-confirm
the formula.
*via clicking Format Cells
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"Sher" wrote:
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.