Ok folks..last one.
IF A2>=95% then payout equals 100%
IF A2=94% then payout equals 94%
IF A2=93% then payout equals 93%
So basically I need code to say that if A2 is above 95% the payout is 100%
94 = 94
93 = 93
92 = 92
and so on down to 50%
ALL IN ONE STATEMENT.
Thanks
This message was edited by investr on 2002-05-02 10:20
IF A2>=95% then payout equals 100%
IF A2=94% then payout equals 94%
IF A2=93% then payout equals 93%
So basically I need code to say that if A2 is above 95% the payout is 100%
94 = 94
93 = 93
92 = 92
and so on down to 50%
ALL IN ONE STATEMENT.
Thanks
This message was edited by investr on 2002-05-02 10:20