Thread: [Solved] Formula that will use different rates depending on the value entered
View Single Post
 
Old 08-11-2016, 09:07 AM
zsteve zsteve is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Mar 2016
Posts: 5
zsteve is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
=SUMPRODUCT(1*(A1>({0,5000,10000})),(A1-({0,5000,10000})),({1.6,-0.4,-0.2}))

where A1 holds the amount entered.
-------

Well it worked - thank you very much

But, I don't understand it.
Reply With Quote