View Single Post
 
Old 08-11-2016, 06:22 AM
zsteve zsteve is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2016
Posts: 5
zsteve is on a distinguished road
Default Formula that will use different rates depending on the value entered

I am looking to create a formula that will allow me to calculate my example below:

First 5,000*1.6
Next 5,000*1.2
Over 10,000*1

For example the Limit entered was 15,000 the formula would have to do something like this.

5000*1.6 = 8000
5000*1.2 = 6000
5000*1 = 5000
=8000+6000+5000
=19,000

I would imagine I need to use IF statements but I just can't seem to get the result I need.
Reply With Quote