Simple If-Then Formula
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.
|