I have several columns with items and quantities. I am trying to compare one set to another and then display a checklist with a statement of the difference and instructions on what to do. Here is what I have so far.
=IF(AND(B13=G13,D13=I13),"2.1 No CPU change needed.",IF(AND(B13<G13,D13=I13),"2.1 Add a CPU "&C13".",IF(AND(B13>G13,D13=I13),"2.1 Remove the 2nd "&C13" CPU.",IF(AND(B13<G13,D13<>I13),"2.1 Remove the "&C13" CPU and add a CPU "&H13".",IF(AND(B13>G13,D13<>I13),"2.1 Change out the CPU and remove a CPU.",IF(AND(B13=G13,D13<>I13),"2.1 Change out the CPU(s).",""))))))
B13 contains the quantity of CPU's in the original machine, G13 contains the quantity of CPU's in the new machine. D13 contains the part number of CPU's in the original machine, I13 contains the part number of CPU's in the new machine. C13 is the description of the CPU from the original machine and H13 is the description of the CPU from the new machine.
What I would like it to do is check if the quantity on both are the same and the part numbers are the same and then display "2.1 No CPU change needed."
If the original machine has 1 CPU and the new machine has 2 CPUs but they are the same part number I want it to display "2.1 Add a 2nd description pulled from H13 CPU."
If the original machine has 2 CPUs and the new machine has 1 CPU but they are the same part number I want it to display "2.1 Remove the 2nd description pulled from C13 CPU."
If the original machine has 1 CPU and the new machine has 1 CPU but they are NOT the same part number I want it to display "2.1 Remove the description pulled from C13 CPU and install a description pulled from H13 CPU."
If the original machine has 1 CPU and the new machine has 2 CPU's but they are NOT the same part number I want it to display "2.1 Remove the description pulled from C13 CPU and install quantity pulled from G13 description pulled from H13 CPUs."
I think I am really close on the formula, but I can not seem to display the statement using the text from the other cells.
Bookmarks