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