Formula that will use different rates depending on the value entered

		Microsoft Office Forums > Microsoft Excel > Excel
Formula that will use different rates depending on the value entered

08-11-2016, 09:07 AM

zsteve

Windows 7 64bit Formula that will use different rates depending on the value entered

Office 2013

Novice

Join Date: Mar 2016

Posts: 5

Quote:

Originally Posted by xor

=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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Marking specific cells depending on start and end time entered	ellebb85	Excel Programming	0	01-17-2016 02:50 AM
different rates on sunday	pascalbidouille	Project	1	07-01-2015 01:58 PM
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM
Viewing Resource Rates	decker	Project	6	02-07-2014 03:23 PM
Formula to select description when code is entered	Natasha	Excel	1	09-25-2011 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:24 AM.