View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default IF Formala Doesn't Work

Make sure, then, that G43 is formatted as General. If it is text, it will
give you the result you have. Set the format and then re-enter 235.

AndyB

"A. Blundon" wrote in message
oups.com...
Calculation is set to automatic. Also I tried hiting F9 a so see if it
would recalc. Still no luck.

Thanks,
AB