# if statement that calculates between pecentages

#### erbbbb

##### New Member
=IF((AND(H19>=0.01,H19<=0.03)),".09")
=IF((AND(H19>=3.01,H19<=0.06)),".08")
=IF((AND(H19>=6.01,H19<=0.09)),".07")

what i was trying to accomplish is if the number in a cell falls between .01 and 3 % make the cell multiply by 9%

if cell is between 3.01 percent and 6% multiply by 8%

i believe between these % is my problem

thank you very much!

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### Andrew Poulsom

##### MrExcel MVP
I think it's just wrongly positioned decimal points:

=IF((AND(H19>=0.01,H19<=0.03)),".09")
=IF((AND(H19>=0.031,H19<=0.06)),".08")
=IF((AND(H19>=0.061,H19<=0.09)),".07")

#### jim may

##### Well-known Member
=IF((AND(H19>=3.01,H19<=0.06)),".08") << 3.01 don't you mean .031
=IF((AND(H19>=6.01,H19<=0.09)),".07") << 6.01 dont you mean .061

Also remove quotes from your last parameter ".09", ".08", ".07"

#### Domski

##### Well-known Member
Maybe use: =LOOKUP(H19,{0.01,0.031,0.061},{0.9,0.8,0.7})

Dom

Replies
1
Views
145
Replies
6
Views
371
Replies
5
Views
409
Replies
1
Views
156
Replies
6
Views
114

1,191,347
Messages
5,986,136
Members
440,004
Latest member
Dynawoman

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back