# IF and OR Formula

#### weaselmcguff

##### Board Regular
Trying to figure out how to do this.

In A1 they are selecting what they are converting FROM
in B1 they are selecting what they are going TO
underneath each box it will show what makes up that kit they selected above it.

In C2:C10 it will show them what they need to order

I am trying to write the formula to where

If in B3 = PartB then you need it automatically for C3, even if it is in A3. But if it is not PartB and it is different than A3 you need it.
If A2=B2 then yu need nothing
if A2 does not equal B2 then you need what is in B2
I want the end result to look similar to what i have below
 KIT1 KIT2 Need PartA PartA PartB PartB PartB PartC PartD PartD

<COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3296" width=103><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3200" width=100><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2176" width=68><TBODY>
</TBODY>

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
can you post some more sample data with desired result ?

i am not getting what actually you need

Basically the only cell I am trying to figure out the formula for is C3

A1 and B1 are Kit Part Numbers.
A2:A10 are parts that make up that kit same for B2:B10

C2 and C4:C10 Code in those cells is if(\$A2=\$B2,"",\$B2) so if A2 = B2 then blank else B2 Value
C3 is my tricky one. If B3 = PartD then C3 = PartD, but if B3 does not equal PartD i want if(\$A3=\$B3,"",\$B3)

I cant figure out how to put that all together in a formula.

Does that explain it more.

cam you pls post some sample data with header of column and where you want to put formula with desired result ?

Hi weasel,

Maybe something like this...

Excel Workbook
ABC
1KitAKitBNeed
2Part APart A
3Part BPart BPart B
4Part CPart DPart D
5Part CPart EPart E
6Part CPart BPart B
Sheet1

AP

Thanks worked perfect

Replies
3
Views
803
Replies
3
Views
715
Replies
1
Views
2K
Replies
1
Views
838
Replies
7
Views
4K

1,196,380
Messages
6,014,958
Members
441,857
Latest member
saraguchi2316

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