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
 

Tarver

Board Regular
Joined
Nov 15, 2012
Messages
74
So cell B9 should be =IF(B7=1,B8*0.1,IF(B7=2,B8*0.2,IF(B7=3,B8*0.3,"ERROR: Cell B7 is not a 1, 2, or 3.")))

Or, you could just make the formula in cell B9 to be =B7/10*B8 That would let you enter any value in B7, and get 10% of the entry.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

ShuStar

Board Regular
Joined
Sep 9, 2015
Messages
89
Office Version
  1. 2010
Platform
  1. Windows
So it's pretty much what Tarver said, but change b1 to b7 as below:

If(b7=1, b8*0.1, if b7=2, b8*0.2, if b7=3, b8*0.3, "Error - check if B7 is 1,2 or 3")))
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
If(b7=1, b8*0.1, if b7=2, b8*0.2, if b7=3, b8*0.3, "Error - check if B7 is 1,2 or 3")))

Hi M.
No matter what i do i get this error message .
 

Attachments

  • Untitled-1.psd.jpg
    Untitled-1.psd.jpg
    63.4 KB · Views: 6

Tarver

Board Regular
Joined
Nov 15, 2012
Messages
74

ADVERTISEMENT

Are you starting the formula with an equal sign (=)?
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
yes , i try to use google exls docs and when i change to >> =If(b7=1, b8*0.1, if (b7=2, b8*0.2, if (b7=3, b8*0.3, "Error - check if B7 is 1,2 or 3"))) then on google works but still not works on excell !!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,068
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Did the formula from post#6 work for you?
Also what is the separator you normally use in a formula, is it a comma or semi-colon?
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
Did the formula from post#6 work for you?
Also what is the separator you normally use in a formula, is it a comma or semi-colon?

Only when open parentheses before B7 then works on google xls docs, on microsoft excel no works, about separator i use comma , is this the problem ?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,068
Office Version
  1. 365
Platform
  1. Windows
If you normally use a comma then that's not the problem.
These work for me
+Fluff New.xlsm
ABC
5
61.6
721.6
881.6
Data
Cell Formulas
RangeFormula
C6C6=(B7*B8*0.1)
C7C7=B7*B8*0.1
C8C8=IF(B7=1,B8*0.1,IF(B7=2,B8*0.2,IF(B7=3,B8*0.3,"Error - check if B7 is 1,2 or 3")))
 

mikie1881

New Member
Joined
Jul 27, 2020
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
If you normally use a comma then that's not the problem.
These work for me
+Fluff New.xlsm
ABC
5
61.6
721.6
881.6
Data
Cell Formulas
RangeFormula
C6C6=(B7*B8*0.1)
C7C7=B7*B8*0.1
C8C8=IF(B7=1,B8*0.1,IF(B7=2,B8*0.2,IF(B7=3,B8*0.3,"Error - check if B7 is 1,2 or 3")))


Inspired from your question about comma or semicolon i change on option to system separator and WORKS perfect ! Thank you again.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,600
Messages
5,523,821
Members
409,538
Latest member
husnafezaahmad

This Week's Hot Topics

Top