# Making a determination on two columns with multiple criteria

#### nathanbrooks

##### New Member
I have two columns that I am wanting to compare and make a decision based on a date range. One column is for inventory receipts and one column is for inventory issues. The logical statement is something like this=

If Cell2>730 and Cell3>730 then Item is Obsolete, Not Obsolete.

Then next formula is something like this if Cell1<4 and If Cell2>730 and Cell3>730 then Item is Obsolete, Not Obsolete.

any suggestions?

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### tusharm

##### MrExcel MVP
Check out Excel help for the AND function.
I have two columns that I am wanting to compare and make a decision based on a date range. One column is for inventory receipts and one column is for inventory issues. The logical statement is something like this=

If Cell2>730 and Cell3>730 then Item is Obsolete, Not Obsolete.

Then next formula is something like this if Cell1<4 and If Cell2>730 and Cell3>730 then Item is Obsolete, Not Obsolete.

any suggestions?

Replies
2
Views
342
Replies
6
Views
319
Replies
3
Views
430
Replies
1
Views
2K
Replies
9
Views
253

1,190,610
Messages
5,981,916
Members
439,743
Latest member
KatieO

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