HELP ME TO SOLVE THIS PROBLEM

A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top