This formula is too advanced for me.
The number series that will appear in Cell A1 are listed below:
4.0 thru 4.999999999, 5.0 thru 5.999999999, 6.0 thru 6.999999999, 7.0 thru 7.999999999, 8.0 thru 8.999999999, 9.0 thru 9.999999999, 10.0 thru 10.999999999, 11.0 thru 11.999999999, 12.0 thru 12.999999999.
I am trying to develop a formula for Cell B1 that will resolve the problem:
Each one of these nine series of numbers above, will have its own multiplier.
Note: The multiplier value will be assigned simply by adjusting the formula.
Example:
4.0 thru 4.999999999 X $5.00, 5.0 thru 5.999999999 X $13.00, 6.0 thru 6.999999999 X $15.00, – Etc. up to: 12.0 thru 12.999999999 X $25.00
Any help would be greatly appreciated.
Thanks
Bookmarks