HELP ME TO SOLVE THIS PROBLEM

[ad2ad79]

Hi every1,

How can I attach sheet to explain column.

OR

I am a small commission agent hiring trucks from outside.

I want to calculate salary(column BC4) automatically IF:

.. C1:BB1 = CONTAINER THAN C4:BB4*30
.. C1:BB1 = BAGS THAN C4:BB4*30
.. C1:BB1 = COILS THAN C4:BB4*35

.. REST OF ALL (C1:BB1)= C4:BB4*22

NOTE: COLUMN C4:BB4 CONTAINS (No. of trips. ie 1 or 2 or 3

WAITING 4 YOUR BEST REPLY

Thanks
Adil.