•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#multiplying numbers
#formula
#factors
#number range
#value ranges
#conditional IF
#Excel
#calculation
#multiplicative factors
#$0-$25
#$25-$250
#$250-$500
#$500+