PLS HELP ME TO SOLVE THIS PROBLEM

  • Thread starter Thread starter ad2ad79
  • Start date Start date
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.
 
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.
Click to expand...

You should NOT post in multiple groups. Wastes our time.
You should have a meaningful subject line such as Commission calculation.
You should FULLY explain problem with examples.

You can not attach a file but you can send direct to ME and I'll take a look.
 
You should NOT post in multiple groups. Wastes our time.

You should have a meaningful subject line such as Commission calculation.

You should FULLY explain problem with examples.



You can not attach a file but you can send direct to ME and I'll take a look.
Click to expand...

Thanks Noted
 
Back
Top