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

=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

"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

"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
---

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
wrote in message
...
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