Calculating the “total” based on “salary” value and its “type” (multiple IF),

[Jamal NUMAN]

Calculating the “total” based on “salary” value and its “type” (multiple IF),



In the attached screenshot and xlsx file, I wanted to calculate the “total” based on the salary value and its type where each type has a factor. For example, if the salary equals 4 with type a, then the total will be 20 (which is 4x5=20). While if the salary is 7 with type b, then the total will be 56 (which is 7x8=56).

I could figure out that this issue could be resolved by using nested IF but as the types increase the IF formula gets complicated. Is there a smart method by which such issue can be resolved?

Thank you

Best

Jamal

[xor]

Maybe like the attached.

[xor]

As an alternative to the formula in the file 'Type Factor Value Total_2' you can use:

=SUMPRODUCT(--(G3=$B$3:$B$10),($C$3:$C$10))*F3

in row 3 and copy down.

[Jamal NUMAN]

Originally Posted by xor

As an alternative to the formula in the file 'Type Factor Value Total_2' you can use:

=SUMPRODUCT(--(G3=$B$3:$B$10),($C$3:$C$10))*F3

in row 3 and copy down.

Thank you very much XOR for the help. the first solution works fine for me.
very much appreciated
best
Jamal

[Pecoflyer]

Don't quote entire posts unnecessarily. Thx