Please i need your help to create formula

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%.

Thank you in advance

Michell
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Putting a formula in B8 that refers to B8 will create a circular reference. I suspect that's not what you want. Can you explain what you are trying to do?
 
Upvote 0
JoeMo is correct, your notion will cause a circular reference.

However, you can put this formula (=B8*(B1*0.1)) in C8 (or where ever) and calculate based on B1 and B8.
 
Upvote 0
ok, sorry because i have no experiance in excell. and my english is not good as well so , i have an excell that calculate some values in simple, in B8 there is a value that must be multiplyied with the value on B7 wihch the value ( B7) changes from 1to3 , if is 1 means 10% , 2 means 20% 3 means 30%. , the results goes to cell B9. I hope to be understanding my text. Regards michell
 
Upvote 0
ok, sorry because i have no experiance in excell. and my english is not good as well so , i have an excell that calculate some values in simple, in B8 there is a value that must be multiplyied with the value on B7 wihch the value ( B7) changes from 1to3 , if is 1 means 10% , 2 means 20% 3 means 30%. , the results goes to cell B9. I hope to be understanding my text. Regards michell
Maybe put this formula in B9:
=(B8*B7*0.1)
 
Upvote 0
I Thank you all for your answers ,apreciate a lot. Best Regards Michell
 
Upvote 0
How about this? This formula can't go in cell B1 or B8, but it can go anyplace else.

=IF(B1=1,B8*.1,IF(B1=2,B8*.2,IF(B1=3,B8*.3,"ERROR, B1 isn't 1, 2, or 3.")))
 
Upvote 0
=IF(B1=1,B8*.1,IF(B1=2,B8*.2,IF(B1=3,B8*.3,"ERROR, B1 isn't 1, 2, or 3.")))

I try to add that you sent me but i got error message , mybe i make mistake but i just copy-paste your formula in cell B10 ,
 
Upvote 0
I will try to explain better this time.
Cel B7 the value manually changes from 1 to 2 or 3
Cell B8 the value in this cell comes from a calculation on B1.
In Cell 9 i want the value of Cell B8 * Cell B7 ( if B7 =1 then *10% if B7=2 then*20% if B7=3 then *30%

I hope I did not tire you.
Thank you again
 
Upvote 0

Forum statistics

Threads
1,212,929
Messages
6,110,743
Members
448,295
Latest member
Uzair Tahir Khan

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top