Thread: My formula show up in the cell instead of a resulting value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default My formula show up in the cell instead of a resulting value
Your cell was formatted as text before you entered the formula.
Format as General and RE-ENTER THE FORMULA (F2, ENTER)

--
Kind regards,

Niek Otten

"Sweetetc" wrote in message
...
I have a look up formula
=VLOOKUP($A2,AFT_CDSCLIAB_LAC!$A:$X,9,FALSE)-VLOOKUP($A2,BEF_CDSCLIAB_LAC!$A:$X,9,FALSE)

Instead of showing the resulting value it displayes the formula
--
Thanks
ETC


Reply With QuoteReply With Quote