#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
I'm not sure what you need. Take a look at differential rates
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
In the attached, a lookup table in E2:F5, formulae in column B showing facto:
=INDEX($F$2:$F$5,MATCH(A2,$E$2:$E$5,1)) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
help with formulas | ferrarifx | Excel | 2 | 11-16-2016 12:04 PM |
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 |
IF Formulas | mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |