ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula help (https://www.excelbanter.com/excel-worksheet-functions/216869-formula-help.html)

Robert

Formula help
 
I'm pulling out my hair. LOL I'm try to create a range. (I think)

If a number falls between two numbers it returns a dollar amount. Example:
The ranges are
LEFT RIGHT
250 250 = $40
500 500 = $100
1000 1000 = $200
2000 2000 = $400
3000 3000 = $600
4000 4000 = $800
5000 5000 = $1000

If the "LEFT" cell's figure is 2500 and the "RIGHT" cell's figure is 3500
the it shows the amount from the 2000 range as $400

I hope that this is clear. Thanks to whomever helps. Much appreciated!!
Robert
--
Thanks much
Robert


All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com