ExcelBanter - View Single Post

Karen

This worked great! Thank you!

"T. Valko" wrote:

See this:

http://mcgimpsey.com/excel/variablerate.html

--
Biff
Microsoft Excel MVP

"Karen" wrote in message
...
Hi,
Can you please help me with figuring out what formula I need for below.

0-85,000 units = $0
85,001 -100,000 units = $2
100,000-150,000 units = $3

if i had 90,000 units in a cell, then my result would be 90000-85000
=5,000
x $2
if i had 105,000 units in a cell,then my result should be 100,000 -85,000
=15,000 x $2
if i had 70,000 units in a cell, then my result should be 0.

I need all 3 if statements in my formula in one cell. Is that possible?
I think once i get this then i can go onto the next tier of the $3 in the
next cell, i hope?!

Thanks in advance,
Karen