Forum Discussion
ojonesjr
Jan 14, 2019Copper 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 e...
Detlef_Lewin
Jan 14, 2019Silver Contributor
Hello
Simply:
=MIN(A1,210000)