Jan 14 2019 06:36 AM
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.
Jan 14 2019 09:21 AM
Jan 14 2019 10:18 AM
That is the way formula works. Did you try it?
Jan 14 2019 11:54 AM
I did and found my cell were not formatted correctly. It is working now. Thank you!