IF statements

  • Thread starter Thread starter S1
  • Start date Start date
S

S1

=IF((i7="1st"),*.50,IF((i7="2nd"),*.25,IF((i7="3rd"),*.12,IF((i7="4th"),*.08,""))))

The goal is to take cell H7 and multiply by I7 if it shows "1st" by .50
(50%), "2nd" by .25 (25%), etc. and place the amount in J7. I think there is
a variable missing. Anyone have any thoughts?

Thanks
 
A formula cannot alter what is in a cell
In some cell other than H7
=H7*IF((i7="1st"),0.50,IF((i7="2nd"),).25,IF((i7="3rd"),0.12,IF((i7="4th"),0.08,""))))
but check what happens if I7 is none of the choices.
Alternative =H7*CHOOSE(--LEFT(I7),0.5,0.25,0.12,0.08)
best wishes
 
On cell J7
IF((i7="1st"),H7*.50,IF((i7="2nd"),H7*.25,IF((i7="3rd"),H7*.12,IF((i7="4th"),H7*.08,""))))
 

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

subtracting dates in an IF statement 2
VLOOKUP and IF Statements 2
nested if statements using "AND" as well as "OR" 2
Transpose between sheets 4
Detecting if AutoFill was used? 2
IF Statement 2
Vlookup 5
problems with "if function 3

Back
Top