How to make conditional multiplying formulas?

  • Thread starter Thread starter Tito
  • Start date Start date
T

Tito

Hi

Depending on the value I chose from a Validation List in
cell B1, I want Excel to multiply A1 by a fixed value. Any
ideas?
More or less is like IF B1 is equal to X then A1*0.15...
and so on...

THanks
 
Hi Tito

i would base the validation list on a list of values in another sheet (e.g.
Sheet2)- in the column next to that list i would put the amounts to multiply
A1 by
then in C1 i would use the VLOOKUP function
=VLOOKUP(B1,Sheet2!A1:B100,2,false)*A1
this says, lookup up the value in B1, in the table in Sheet2, return the
value in the second column where there's an exact match and multiply this by
what's in A1

Hope this helps
Cheers
julieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I enter formula sum(range+range)*0.15 sumif(range>=3) 2
Formula 12
if conditional formula required 13
HOW DO I MULTIPLY BY A VALUE NOT MORE THAN A CERTAIN NUMBER 7
The real Horizontal Formula question 4
Paste Special Formula Multiply feature doesn't work anymore 2
Trying to calculate results in one cell, based on data of another 9
Conditional Formatting 6

Back
Top