Thread: Formula works in google sheets but not in Excel, how to make it works?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pat[_26_] Pat[_26_] is offline
external usenet poster
  
Posts: 1
Default Formula works in google sheets but not in Excel, how to make it works?
=IF(D2="","",LOOKUP(D2,{0,4.99,9.99,24.99,99.99,14 99.99},{"1","1.5","2.5",D2*0.1,(0.05*(D2-100))+10,(0.03*(D2-1500))+80}))

This formula works in google sheets but not in Excel on my PC.

How to make it works on Excel? "Using Excel 2007"

Thanks.
Reply With QuoteReply With Quote