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.

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

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

Vaya con Dios,
Chuck, CABGx3



"InsBrokerJayne" wrote:

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.

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

"InsBrokerJayne" wrote in message
...
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.

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

What if F2=50?

Eric.


"InsBrokerJayne" wrote in message
...
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.

Just another way:

=((F250)+(F2=500))*25

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


In article ,
"InsBrokerJayne" wrote:

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.

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!
==============================================


"InsBrokerJayne" wrote in message
...
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.

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

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"InsBrokerJayne" wrote in message
...
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.

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