Thread: Lookup Formula not working completely
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newsgal Newsgal is offline
external usenet poster
  
Posts: 24
Default Lookup Formula not working completely
=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