PLS 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.

 

[Don Guillett]

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.

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.

 

[ad2ad79]

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.

Thanks Noted