Vlookup formula porblem

K

Kit

Hi

I am trying to do a formula that will compare a sales
total in cell E4 with a value ( 60) stored in cell C15. If
the sales total is greater than than the C15 value it will
then calculaate a discount using a value (10%) stored in
cell C10 and store the discount figure in cell D4. If the
total is less than 6o it will return a value of 0.00 in
the target cell.
The % value changes frequently so has to be a cell
reference rather than a number.
I have tried variations on the IF function and V LOOKUP
function but can't find a way to get it to do the
percentage calculation.
Any suggestions for a formula to do this?
Thanks
 
N

Norman Harker

Hi Kit!

Try the following in D4

=IF(E4>=$C$15,E4*$C$10,0)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
K

Kit

Great!!!!!!!!!!!!!!
thanks
-----Original Message-----
Hi Kit!

Try the following in D4

=IF(E4>=$C$15,E4*$C$10,0)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Top