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.

 

[joeu2004]

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

=22*SUM(C4:BB4) + 8*SUMIF(C1:BB1,"container",C4:BB4)
+ 8*SUMIF(C1:BB1,"bags",C4:BB4) + 13*SUMIF(C1:BB1,"coils",C4:BB4)

Note: 8 = 30-22, and 13 = 35-22.

 

[ad2ad79]

=22*SUM(C4:BB4) + 8*SUMIF(C1:BB1,"container",C4:BB4)

+ 8*SUMIF(C1:BB1,"bags",C4:BB4) + 13*SUMIF(C1:BB1,"coils",C4:BB4)



Note: 8 = 30-22, and 13 = 35-22.

Hello Joeu,

Thanks the solution.I solved my problem.
Thanks very much & Thumbs Up.

Kindly do let me know actually the work of "*" and "+" in this function.
I think :
.. array variable
.. * = and
.. + = or

If I know the actuall name I can deeply study in HELP section of excel

Thanking u once again,

Kind Regards,

Adil.

 

[joeu2004]

=22*SUM(C4:BB4) + 8*SUMIF(C1:BB1,"container",C4:BB4)
+ 8*SUMIF(C1:BB1,"bags",C4:BB4) + 13*SUMIF(C1:BB1,"coils",C4:BB4)

[....]
Kindly do let me know actually the work of "*" and "+" in this function.
I think :
. array variable
. * = and
. + = or

Methinks you have been reading too many esoteric examples using SUMPRODUCT.

Here, they do simple multiplication and addition, with no other purpose.

If I know the actuall name I can deeply study in HELP section of excel

The help pages to read are:
SUM
SUMIF
Calculation operators

Unfortunately, the offline (local) help search is deficient in Excel 2010
and perhaps later. Searching for "calculation operators" yields nothing
useful.

You can find an appropriate help page using online help in Excel or a
browser search engine. Here:
http://office.microsoft.com/en-us/excel-help/about-calculation-operators-HP005198697.aspx

 

[ad2ad79]

=22*SUM(C4:BB4) + 8*SUMIF(C1:BB1,"container",C4:BB4)
+ 8*SUMIF(C1:BB1,"bags",C4:BB4) + 13*SUMIF(C1:BB1,"coils",C4:BB4)

[....]

Kindly do let me know actually the work of "*" and "+" in this function.

I think :

. array variable

. * = and

. + = or

Methinks you have been reading too many esoteric examples using SUMPRODUCT.



Here, they do simple multiplication and addition, with no other purpose.

If I know the actuall name I can deeply study in HELP section of excel

The help pages to read are:

SUM

SUMIF

Calculation operators



Unfortunately, the offline (local) help search is deficient in Excel 2010

and perhaps later. Searching for "calculation operators" yields nothing

useful.



You can find an appropriate help page using online help in Excel or a

browser search engine. Here:

http://office.microsoft.com/en-us/excel-help/about-calculation-operators-HP005198697.aspx

Thanks joe

Noted.