IF conditional Statements...again

investr

New Member
Joined
Apr 30, 2002
Messages
10
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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
On 2002-05-02 10:19, investr wrote:
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 /board/images/smiles/icon_smile.gif
This message was edited by investr on 2002-05-02 10:20

Is it not:

=(A1>=95%)*100%+(A1<95%)*A1

or, if you like,

=IF(A1>=95%,100%,A1)
 
Upvote 0
I have this
=IF(A9>=95%, 100%, IF(A9=94%, 94%))

but that doesn't help me with 93% = 93% and 92% = 92% etc...

I need this ALL in ONE statement

So if I plug in 96% in A2 then A3 says 100%
if I plug in 94% in A2 then A3 says 94%
and so on..get it?
 
Upvote 0
On 2002-05-02 10:29, investr wrote:
I have this
=IF(A9>=95%, 100%, IF(A9=94%, 94%))

but that doesn't help me with 93% = 93% and 92% = 92% etc...

I need this ALL in ONE statement

So if I plug in 96% in A2 then A3 says 100%
if I plug in 94% in A2 then A3 says 94%
and so on..get it?

No, I don't get it.

Did you try what I suggested?
 
Upvote 0
Hey again,

I'm still not sure what's wrong with:

=IF(A2>=95%,100%,A2) '--as you remember this was posted in your other thread as well as Aladin's post above.

Does it have something to do with your lower extreme of 50%? If A2<50% do you want the formula to still output 50%?

For example:
=IF(A2>=95%,100%,IF(A2<50%,50%,A2))

This basically states:
IF A2>=95% then output 100%
IF A2<50% then output 50%
Otherwise output A2 - this seems to fit your description

If this is incorrect then please specify exactly what we're missing - as there appears to be something I'm not quite getting.

Hope that helps
Adam
 
Upvote 0
I need this all on ONE formula.

This is what I need cell B2 to have happen..in my laymen terms...

IF A2>=95% then output 100%
IF A2=94% then output 94%
IF A2=93% then output 93%

Down to 85% would be fine.

So if I knew how to combine all those conditions into one I would do it. That is why I am posting one at a time. :)) So I need the formula to do all of what I stated above in ONE formula for cell B2

_________________
thanks!
C Hawk
This message was edited by investr on 2002-05-02 10:58
This message was edited by investr on 2002-05-02 10:59
 
Upvote 0
=if(or(a2>.95,a2=.95),1,a2)

This will return the value that is in A2 as your payout if it is less than .95
 
Upvote 0
Ok

I'm going to break out your conditions in effort to see where the miscommunication is.

Condition 1:

Based on your description: the output value that you need in B2 appears to be the exact same as the input value in A2 -as long as A2 is <95%.

In Summary for Condition 1:

IF A2<95% then B2=A2

'e.g. if A2=94% then output the value 94% in cell B2. Likewise if A2=65% then B2 outputs 65%. --Does this not agree with your example?

Condition 2:

You want B2 to output 100% if A2 holds a value greater than or equal to 95%. So if A2=95%, then B2 outputs 100%. Likewise if A2=99% then B2 outputs 100%.

In Summary for condition 2:
IF A2>=95% then B2=100%


Total formula:

Therefore merging these 2 conditions into one formula:

=IF(A2>=95%,100%,A2) '-typed in B2

I'm really not seeing any difference in explanations between your last few posts. This formula seems to cover all requested conditions.

Any help?
Adam
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top