•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