Thread: Lookup Formula not working completely
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
  
Posts: 207
Default Lookup Formula not working completely
It's working for me....is M11 formatted as percentage?


"Newsgal" wrote in message
...
=LOOKUP(M11,{0,0.98,1},{0,"$750.00","$1000.00"})
This formula works fine if M11=100+%. However, it's not working when M11 =
98%.
Help!
--
News Gal


Reply With QuoteReply With Quote