=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"S1" (donotspam) wrote in message
...
=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

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


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"S1" wrote:

=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