formula cell value multiply by percentage

[Guest]

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

 

[Guest]

=IF(D5<100,D5*0.25,IF(D5<999,D5*0.2,D5*0.15))

What happens if D5 = 100 OR 999

HTH
Michael M

 

[Guest]

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.15},2))

Copy G5 down if required,
to return correspondingly for other values in D6, D7, ...

---

 

[Biff]

Hi!

Try this:

=G5*LOOKUP(D5,{"",0,1,100,1000},{0,0,0.25,0.2,0.15})

If D5 is either empty, zero or a formula blank the result will be 0.

Biff

"formula using percentage question" <formula using percentage
(e-mail address removed)> wrote in message
news[email protected]...