Deduction of Percentage value

[annadinesh]

Dear Experts
I have a formula in cell D10
=IF(K1<90,HLOOKUP(D5,EW90DAYS!B2:AI29,2,0)*1.18-N10,HLOOKUP(D5,Database!B2:AI43,2,0)*1.18-N10)

and I enter a value of percentage on H10

I want whatever value comes in d10 as per above formula and if I enter a percentage value on H10 like 5% it should deduct the percentage value from D10 and shows the deducted amount

example:
Value on D10 7550.00
If I put 5% on H10

then the value of D10 should returns 7172.50

Please provide an advice

Dinesh Saha

 

[Peter_SSs]

Try this

=(HLOOKUP(D5,IF(K1<90,EW90DAYS!B2:AI29,Database!B2:AI43),2,0)*1.18-N10)*(1-H10)