•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Multiplying numbers by different factors based on number range
Our take
Are you struggling to apply different multiplication factors to varying number ranges in your spreadsheet? If your current formula only accounts for numbers above and below 25, it's time for an upgrade. Imagine seamlessly multiplying values based on defined thresholds: $0-$25 by 3, $25-$250 by 2, $250-$500 by 1.75, and $500+ by 1.5. This transformation not only simplifies your calculations but also enhances your data analysis. Continue reading to discover the tailored formula that can elevate your spreadsheet's functionality.
Any help is greatly appreciated... Looking for a formula that can multiply numbers by 4 different factors based on the number range. The one i currently use just does less than 25 and more than 25. =IF(A4>25,25,A4)*3+IF(A4>25,A4-25,0)*2
I'd like to do the following:
$0-$25 x 3
$25 - $250 x 2
$250 - $500 x 1.75
$500+ x 1.5
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to make a formula for multiplying one cell by a specific number, depending on specific text in another cell.Hi! I'm working on a sheet for work and need some help, as I have little to no excel experience. I'm trying to create a formula where, if the number 2 is in e15, multiply e12($ accounting value) by 1.6, if the numbers 3 is in e15, multiply e12 by 2.2, and so on and so on, all within a single cell. Is there a way to do this? submitted by /u/biscuit_4_life [link] [comments]
- How do you write an IF formula that changes the value based on which range, out of two ranges, the original value fell in?I'm entering number values in Column A and I want Column B (where I'm inputting the formula) to populate either a 1 or a -1 based on which range (of two ranges) the value in Column A falls within. The conditions are: If Column A value is between 1-8, then Column B will be 1. If Column A value is between 9-21, then Column B will be -1. If Column A value is outside the two ranges (below 1 or above 21), then Column B can/should say something like FALSE. The formulas I've tried so far (and which failed) are: =IF(OR(AND(A2>=1,A2<=8),1)AND(A2>=9,A2<=21),-1) =IF(AND(A2<=1,A2>=8),1)OR(AND(A2>=9,A2<=21),-1)) Thank you in advance for all of your suggestions/help. submitted by /u/LifeisSuperFun21 [link] [comments]
- Looking for a better way to do a multplication formulaGoing to attempt to word this where it is understandable. Right now I am having to manually type in the cell number into my formula for each area I would need it. For example =A35*2 written in cell A37 and having the *2 number two spaces above. Do I need to keep writing the cell numbers over and over in each space or is there an option to list *two cells above* multiplied by 2? Photo of what I am trying to accomplish. The values would obviously be different each use of this function. https://preview.redd.it/fnmp1dy6dj0h1.png?width=414&format=png&auto=webp&s=fdd86045c131652b9f2f79ec52bfcff8fdf7d690 submitted by /u/lilwigglyyak [link] [comments]