• 409K Members
• 11.4K Online
• 466K Conversations

New Contributor

# Help with Excel IF and AND or OR functions

Hi,

I am working on  a pension analysis.  Here is what I am trying to accomplish:

If the salary is less than or equal to 210,000 then return amount in that cell.  If the salary is greater than or equal to 210,000 then return 210,000.  I am not able to get it to return the amounts.  Any help on this is appreciated.  I been working on the IF(OR function but can only get half to work.

4 Replies

# Re: Help with Excel IF and AND or OR functions

Hello

Simply:

`=MIN(A1,210000)`

# RE: Help with Excel IF and AND or OR functions

thank you for the formula. it only gives me part of the challenge. I need the formula to show me any salary that is in the cell that will be below 210000 as well. So, if less than or equal to 210000 also give that value...it could be 209,000, 150,000, 97,000... 210000 is the cap.

# Re: RE: Help with Excel IF and AND or OR functions

That is the way formula works. Did you try it?

# Re: RE: Help with Excel IF and AND or OR functions

I did and found my cell were not formatted correctly. It is working now.  Thank you!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies