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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,190
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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?
 

RayFrye

Board Regular
Joined
Jan 31, 2005
Messages
81
Office Version
  1. 365
  2. 2019
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.
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

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
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,190
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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)
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

I Thank you all for your answers ,apreciate a lot. Best Regards Michell
 

Tarver

Board Regular
Joined
Nov 15, 2012
Messages
74
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.")))
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
=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 ,
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,602
Messages
5,523,831
Members
409,539
Latest member
Re1ease

This Week's Hot Topics

Top