IF formula help! pretty please.

[KCALDERON5894]

Hi There I have a formula for rates that works =IF(B4<350000,1100,IF(B4<750000,4.179,IF(B4<1500000,4.104,4.028))) which is based on the Revenue entered in (B4) - it assigns the correct rate then I have the price (B9) set to multiply by (B4) to get the price HOWEVER for revenues of under 350000 dont have a rate, they have a Minimum price $1,100 so when anything under 350K is entered it screws up my price box because it multiplies the min price with the revenue which is not correct. Is there any way to add a rule that if revenue (B4) is less than 350,000 the premium is $1,100? to =B4*B8/1000 in (B9)? To calculate right price?[TABLE="width: 584"]
<tbody>[TR]
[TD]Revenue [/TD]
[TD]$350,000[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Limit[/TD]
[TD]$1,000,000[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rate[/TD]
[TD]4.179[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Price [/TD]
[TD]$1,463[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Limits[/TD]
[TD]Rate[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]$1,000,000[/TD]
[TD="align: right"]4.179[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]5.225[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]$2,000,000[/TD]
[TD="align: right"]5.225[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col></colgroup>[/TABLE]

 

[Michael M]

Like this

=IF(B4<350000,B4*B8/1000,IF(B4<750000,4.179,IF(B4<1500000,4.104,4.028)))

 

[bbott]

Hello,
Try this formula in cell B9:
=IF(B4<=350000,1100,B4*B8/1000)