# Multiple IF with multiple conditions

#### dineshhegde_kh

##### New Member
Hi,

I have to use combination of IF & VLOOKUP conditions with OR function for 7 conditions
below is the screenshot of the same with one formula,

(IF(\$B\$4="(All)",(SUMIFS('Person Month'!\$J:\$J,'Person Month'!\$U:\$U,\$A12)),IF((VLOOKUP(\$B\$4,DATA!\$C:\$C,1,FALSE))=\$B\$4,(SUMIFS('Person Month'!\$J:\$J,'Person Month'!\$U:\$U,\$A12,'Person Month'!\$M:\$M,\$B\$4)),0)))

-- removed inline image ---

I want to use the same formula for 7 conditions.

Please any help me to solve this.

Regards,
Dinesh Hegde

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Replies
7
Views
148
Replies
10
Views
239
Replies
6
Views
282
Replies
14
Views
778
Replies
1
Views
839

1,203,762
Messages
6,057,218
Members
444,914
Latest member
Mamun12345

### 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