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.

[TABLE="width: 576"]
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl67, width: 192, colspan: 3"]Wheels Purchased in 2020:[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]No deal[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65, colspan: 3"]Range from:[/TD]
[TD]Range to:[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64, colspan: 3"]$ rebate earned per wheel[/TD]
[/TR]
[TR]
[TD="class: xl66, colspan: 3"]6225[/TD]
[TD="align: right"]6725[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]$10 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, colspan: 3"]6726[/TD]
[TD="align: right"]7225[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]$15 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66, colspan: 3"]7226[/TD]
[TD="align: right"]7500[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]$20 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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