3 Part IF Formula Help

[KrisWenzel]

I need to make a 3-part IF formula that says...

If L92 is less than $2,500, put zero.
If L92 is greater than $2,500 but no more than $5,000, then multiply L94 x I92.
If L92 is greater than $5,000, take L92 minus $5,000 and multiply it by I92

Thanks in advance

[Moo the Dog]

Try this:

=IF(L92<2500,0,IF(AND(L92>=2500,L92<=5000),L94*I92,(L92-5000)*I92))

- Moo

[Pete_UK]

Try this:

=IF(L92<2500,0,IF(L92<=5000,L94,L92-5000))*I92

Hope this helps.

Pete

[KrisWenzel]

Thanks everyone!!