Calculator formula using If/Then without a macro?

[paquirl]

Does anyone know how to do this?

Wanting to make a calculator where we input a number into a cell, say D1.
IF the number falls within a particular range it gets multiplied by a particular number and the answer is displayed somewhere, say G1.

If the number falls within range 6225-6725, then it is multiplied by 10 and the answer displayed in G1 as a dollar amount.
If the number falls within range 6726-7225, then it is multiplied by 15 and the answer displayed in G1 as a dollar amount.
If the number falls within range 7226-7500, then it is multiplied by 20 and the answer displayed in G1 as a dollar amount.

Help?!

 

[Fluff]

What happens if the number is outside those ranges?

 

[paquirl]

the answer can say something like "no deal"

 

[Fluff]

Ok, how about
=IF(OR(D1<6225,D1>7500),"No deal",D1*IF(D1<6726,10,IF(D1<7226,15,20)))

 

[paquirl]

Ok, how about
=IF(OR(D1<6225,D1>7500),"No deal",D1*IF(D1<6726,10,IF(D1<7226,15,20)))

I put this formula into G1 where the result is displayed. It immediately says no deal.
No matter what I put into D1 nothing changes in G1. So I guess this does not work.

Wheels Purchased in 2020:				No deal
Range from:	Range to:			$ rebate earned per wheel
6225	6725			$10
6726	7225			$15
7226	7500			$20

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Fluff]

So I guess this does not work.

Yes it does, what are you putting into D1?

Book1
	D	E	F	G
1	0			No deal
2	6225			62250
3	6726			100890
4	7220			108300
5	7228			144560
6	7501			No deal
Sheet3

Cell Formulas
Range	Formula
G1	=IF(OR(D1<6225,D1>7500),"No deal",D1*IF(D1<6726,10,IF(D1<7226,15,20)))

 

[paquirl]

My bad .. I put it in the wrong cell. It works !!

 

[Fluff]

You're welcome & thanks for the feedback