Calculating 0% in a HLOOKUP function

[haloperidal]

I am trying to calculate discounts based on the dollar value of purchases. I have created an HLOOKUP formula to calculate the price with the discount the discount. It all works well except the 0% discount returns a 0.00 value instead of the value of the cell originally referenced. I know there has to be a relatively simple fix for this, but I have not been able to figure it out. Please help.

[TMS]

Well what would be helpful is for you to tell us what the formula is. And even better if you did that in the context of a sample workbook.

Regards, TMS

[martindwilson]

care to share your formula?

[haloperidal]

Thanks for the quick response y'all.

The formula I am using is: =G3*HLOOKUP(J3,Rate,2,FALSE). G3 has a value of 1555. J3 is the cell this value is being placed in.

The Rate table is below:

AA X Y Z
0% 25% 50% 65%


The above formula figures the X,Y, and Z values correctly, but the AA comes out as 0.

[martindwilson]

change aa rate to 1 or 100% then when its aa g3*1=g3
or since its a discount
=G3-G3*HLOOKUP(J3,Rate,2,FALSE) Will give the new price

[haloperidal]

Thanks, Guru. That solved the problem.

[protonLeah]

This thread is in the wrong forum!