Multiple IF formula functions help

[NUppal]

Hi,

I need help with the if formula. I got a basic formula down but now I need to add multiple functions to it and am getting stuck.

This was the formula I was able to get for column CN:

=IF([@[Years of Service]]*[@[Severance Weeks per Policy]]>[@[Min Weeks]],[@[Years of Service]]*[@[Severance Weeks per Policy]],[@[Min Weeks]])

If CJ times CL is greater than CM, than CN should be CJ times CL. If not it should equal to CM.

The problem is column CN is supposed to max out at 54. No one can have more then 54 employee severance weeks, and no one can have less then the minimum number of weeks.

So I am trying to write:

If CJ * CL > CM, than CN = CJ * CL. If not, CN = CM and if CJ*CL>54, CN = 54. If not, CN = CJ*CL except if it is less then CM.

 

[Fluff]

How about

=MAX(54,IF([@[Years of Service]]*[@[Severance Weeks per Policy]]>[@[Min Weeks]],[@[Years of Service]]*[@[Severance Weeks per Policy]],[@[Min Weeks]]))

 

[NUppal]

I've tried that but doesn't work. The output is still 106.21 (CJ*CL)

 

[Fluff]

Oops not thinking. It should be Min not Max.

 

[NUppal]

thank you so much!! it worked

 

[Fluff]

You're welcome & thanks for the feedback.