View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Sher Sher is offline
external usenet poster
 
Posts: 22
Default Creating an "F" Statement

Good Morning Max -

Made the change formula cell to General and still no change. Not sure why
this isn't working.

"Max" wrote:

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.