# Multiple IF formula functions help

#### NUppal

##### New Member
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.

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=MAX(54,IF([@[Years of Service]]*[@[Severance Weeks per Policy]]>[@[Min Weeks]],[@[Years of Service]]*[@[Severance Weeks per Policy]],[@[Min Weeks]]))``

#### NUppal

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

#### Fluff

##### MrExcel MVP, Moderator
Oops not thinking. It should be Min not Max.

#### NUppal

##### New Member
thank you so much!! it worked

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
5
Views
192
Replies
10
Views
546
Replies
4
Views
427
Replies
6
Views
470
Replies
1
Views
107

1,147,743
Messages
5,742,936
Members
423,765
Latest member
PaulD1984

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back