Simple If-Then Formula

[InsBrokerJayne]

I am trying to set up a simple if-then formula. I want three possible
outcomes.

Here's the deal:
I want a formula that will do the following:
If F2 is greater than $50.00 but less than $500.00, the value for G2 should
be $25.00.
If F2 is greater than or equal to $500.00, the value for G2 should be
$50.00.
If F2 is less than $50.00, the value for G2 should be 0.

Please help.

 

[CLR]

IN G2, put..........

=IF(F2<50,0,IF(F2<500,25,50))

Vaya con Dios,
Chuck, CABGx3

 

[Anne Troy]

Try this, Jayne:
=IF(AND(F2>50,F2<500),25,IF(F2>=500,50,0))
************
Anne Troy
www.OfficeArticles.com

 

[Eric]

=IF(F2>=500,50,IF(F2>50,25,0))

What if F2=50?

Eric.

 

[JE McGimpsey]

Just another way:

=((F2>50)+(F2>=500))*25

You don't say what should happen if F2=50, so I assumed the result
should be zero.

 

[RagDyer]

This returns 25 if F2 also = 50:

=AND(F2>=50,F2<500)*25+(F2>=500)*50

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Sandy Mann]

=IF(F2<>"",(F2>=50)*25+(F2>=500)*25,"")

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[InsBrokerJayne]

Thank you everyone! I really appreciate your help!
-Jayne