"formula using percentage question" wrote:
I am trying to create a formula for the following:
If cell D5<$100 then multiply by 25% in cell G5
If cell D5=$100 and <$999 then multiply by 20% in cell G5
If cell D5$999 then multiply by 15% in cell G5
Assuming the line:
If cell D5$999 then multiply by 15% in cell G5
actually should have read as:
If cell D5=$999 then multiply by 15% in cell G5
(for consistency reasons <g)
then one way is to use VLOOKUP with a standalone table_array ..
In G5:
=IF(D5="","",D5*VLOOKUP(D5,{0,0.25;100,0.2;999,0.1 5},2))
Copy G5 down if required,
to return correspondingly for other values in D6, D7, ...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---