Hi Michael, sorry about earlier. I now have all the criteria needed to enter into one formula. I’m not sure if this is possible due to its length. Please find below the conditions to be included in the formula. Thank you SO much in advance.
=IF (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “IF – VVS” then D2 is A2*1250), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “IF – VVS” then D2 is A2*1000), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “IF – VVS” then D2 is A2*750), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “IF – VVS” then D2 is A2*490), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “IF – VVS” then D2 is A2*360), (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “VS” then D2 is A2*1000), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “VS” then D2 is A2*850), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “VS” then D2 is A2*680), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “VS” then D2 is A2*420), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “VS” then D2 is A2*300), (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “SI1” then D2 is A2*730), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “SI1” then D2 is A2*650), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “SI1” then D2 is A2*580), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “SI1” then D2 is A2*390), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “SI1” then D2 is A2*240), (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “SI2” then D2 is A2*600), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “SI2” then D2 is A2*550), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “SI2” then D2 is A2*500), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “SI2” then D2 is A2*350), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “SI2” then D2 is A2*210), (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “SI3” then D2 is A2*500), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “SI3” then D2 is A2*460), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “SI3” then D2 is A2*440), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “SI3” then D2 is A2*310), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “SI3” then D2 is A2*180), (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “I1” then D2 is A2*460), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “I1” then D2 is A2*430), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “I1” then D2 is A2*420), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “I1” then D2 is A2*260), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “I1” then D2 is A2*150), (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “I2” then D2 is A2*400), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “I2” then D2 is A2*380), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “I2” then D2 is A2*350), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “I2” then D2 is A2*220), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “I2” then D2 is A2*130), (A2 is 0.01 to 0.03 and B2 is “D – F” and C2 is “I3” then D2 is A2*330), (A2 is 0.01 to 0.03 and B2 is “G – H” and C2 is “I3” then D2 is A2*300), (A2 is 0.01 to 0.03 and B2 is “I – J” and C2 is “I3” then D2 is A2*270), (A2 is 0.01 to 0.03 and B2 is “K – L” and C2 is “I3” then D2 is A2*160), (A2 is 0.01 to 0.03 and B2 is “M – N” and C2 is “I3” then D2 is A2*100)
If this cannot be done, please show me another way. Thank you SO VERY MUCH in advance.