Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula that will use different rates depending on the value entered Formula that will use different rates depending on the value entered
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2016, 08:58 AM
xor xor is offline Formula that will use different rates depending on the value entered Windows 10 Formula that will use different rates depending on the value entered Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

=SUMPRODUCT(1*(A1>({0,5000,10000})),(A1-({0,5000,10000})),({1.6,-0.4,-0.2}))

where A1 holds the amount entered.
Reply With Quote
  #2  
Old 08-11-2016, 09:07 AM
zsteve zsteve is offline Formula that will use different rates depending on the value entered Windows 7 64bit Formula that will use different rates depending on the value entered Office 2013
Novice
Formula that will use different rates depending on the value entered 		 
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
Reply

« Previous Thread | Next Thread »


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
Formula that will use different rates depending on the value entered 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
Formula that will use different rates depending on the value entered Viewing Resource Rates decker Project 6 02-07-2014 03:23 PM
Formula that will use different rates depending on the value entered 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 05:29 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft