# Help with IF

#### helpprod

##### New Member
Hi all

What I need to be able to do is if 1 or 2 is in B6 then * 8% if 3 is in B6 then *9% if 4 is in B6 * 10% and if 5 is in B6 * 11% if 6 is in B6 * by 12%. all has to be in one cell

If someone can help me out with this that would be great

Thanks
Ryan

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Ryan,

If I'm not mistaken you'll run into a circular reference doing that. A macro however will do it.

i am not the best at macros any help with those would be good as weill

On 2002-10-14 22:47, helpprod wrote:
Hi all

What I need to be able to do is if 1 or 2 is in B6 then * 8% if 3 is in B6 then *9% if 4 is in B6 * 10% and if 5 is in B6 * 11% if 6 is in B6 * by 12%. all has to be in one cell

If someone can help me out with this that would be great

Thanks
Ryan

Are you * a cell value by x% and not the value of B6?
This message was edited by The Idea Dude on 2002-10-14 23:06

this is what i had for 2 numbers
=IF(B6=2,(B7*0.08),(B6=3)*(B7*0.09))

Note sure if this is what you want

=IF(B6<=2,B6*8%,IF(B6=3,B6*9%,IF(B6=4,B6*10%,IF(B6=5,B6*11%,IF(B6=6,B6*12%,FALSE)))))

Thanks but i need it to * a different cell
if d6=3*d7*9%

On 2002-10-14 23:16, helpprod wrote:
Thanks but i need it to * a different cell
if d6=3*d7*9%

Simply change the B6*8% to D7*8% etc

Does this help

On 2002-10-14 23:16, helpprod wrote:
Thanks but i need it to * a different cell
if d6=3*d7*9%

So the formula would be

=IF(D6<=2,D7*8%,IF(D6=3,D7*9%,IF(D6=4,D7*10%,IF(D6=5,D7*11%,IF(D6=6,D7*12%,FALSE)))))

That worked you guys rule

need help on another problem but will post new message
Thank you
Ryan

Replies
1
Views
182
Replies
2
Views
309
Replies
4
Views
229
Replies
0
Views
105
Replies
15
Views
551

1,218,695
Messages
6,143,951
Members
450,517
Latest member
Rovex

### 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