IF Statement
 

If a1 has a value less than 11908.00 a2 should return 25.00
If al has a value more than 230954.00 a2 should return 485.00
if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00

Can someone please help me with this.

Thank you!

IF Statement
 

=IF(A1<11908,25,IF(A1<=230954,0,485))

--
Best Regards,

Luke M
"Tina" wrote in message
...
If a1 has a value less than 11908.00 a2 should return 25.00
If al has a value more than 230954.00 a2 should return 485.00
if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00

Can someone please help me with this.

Thank you!

IF Statement
 

hI Tina

=IF(A1<11908,25,IF(A1230954,485,0))

"Tina" wrote:

If a1 has a value less than 11908.00 a2 should return 25.00
If al has a value more than 230954.00 a2 should return 485.00
if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00

Can someone please help me with this.

Thank you!

IF Statement
 

Check out another approach:
=25*(A1<11908)+485*(A1230954)
Micky


"Tina" wrote:

If a1 has a value less than 11908.00 a2 should return 25.00
If al has a value more than 230954.00 a2 should return 485.00
if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00

Can someone please help me with this.

Thank you!