Function/formula to compare amounts with Excel 2013

[lal008]

I have Excel 2013 and I am trying to set up a formula that will compare if the total of cell A1*$14 is less than $500, then I want it to enter the $500 minimum. If it is more than $500, I want it to enter the larger dollar amount.

I am wondering if this is possible with my version of Excel because I do not believe that I have the IFS function available. This is the formula that is not working for me:

(A1*14>500,A1*14,A1*14<500,500)

Thanks

 

[Fluff]

How about
=MAX(A1*14,500)

 

[lal008]

Thank you - that should work! I was overthinking it!

 

[Fluff]

You're welcome & thanks for the feedback