VLOOKUP - Multiply by a percentage if appropriate

[Hoopsah]

Hi All,

Wonder if you can help.

I've attached a sample worksheet showing roughly what I'm trying to achieve - I'm completely stumped.

Column B just shows an item code.
Column C shows the quantity
Column D is the rate for the item
Column E is where the formula that I need help with is.

If (In column E) it looks up the table and there is a whole number then just multiply rate x quantity. BUT, if the rate is a percentage then multiply by the percent.

I can only get it to multiply the whole number and not differentiate.

I've added a column (F) to show the answer that it should be.

Thanks all

(P.S. I'll probably be posting this in Mr Excel too as I'm really hoping to have an answer before my team meeting tomorrow - Thanks again)

Hoopsah

[arnelgp]

the formula on E3:

=IF(D3<1,1+D3,D3)*C3

copy it down to the bottom.

[Hoopsah]

That is brilliant!!!

Thank you arnelgp - I love this forum