Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-06-2018, 07:55 AM
Nexia Nexia is offline Multi value Formulas Windows 10 Multi value Formulas Office 2007
Novice
Multi value Formulas
 
Join Date: Apr 2018
Posts: 1
Nexia is on a distinguished road
Default Multi value Formulas

I am trying to write a formula that will use a factor to multiply within the limits below.



to 10 0.0021
10 - 20 0.0017
20 - 30 0.0007
over 30 0.0004

I can complete when only 3 options but am having difficulty adding the fourth variable.

can anyone help?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi value Formulas help with formulas ferrarifx Excel 2 11-16-2016 12:04 PM
Multi value Formulas VBA formulas zhead Excel Programming 17 02-09-2016 03:41 AM
Using Right and Len formulas together PDGood Excel 4 11-20-2015 06:50 AM
formulas MSA5455 Excel 3 12-19-2014 01:50 AM
Multi value Formulas IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 PM.


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