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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,067
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,108,599
Messages
5,523,815
Members
409,537
Latest member
AlfredSiauw

This Week's Hot Topics

Top