try this formula: (replace red values as necessary) same formula in sample attached)
how many combinations can be in Columns C and D?
If there are too many, we need another approach...
=IF(AND(C2="Xerox";D2="Short")=TRUE;B2*2;IF(AND(C2="Print";D2="Short")=TRUE;B2*3;IF(AND(C2="Xerox";D2="Long")=TRUE;B2*5;IF(AND(C2="Print";D2="Long")=TRUE;B2*4;""))))
|