|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating the “total” based on “salary” value and its “type” (multiple IF),
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 |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Quote:
very much appreciated best Jamal |
#5
|
||||
|
||||
Don't quote entire posts unnecessarily. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
How obtain accurate total of hours estimated of all subtasks that are a certain type? | pcumming | Project | 3 | 05-14-2014 05:45 PM |
VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |
Calculating a cell value based on many variables | malawimick | Excel | 0 | 12-14-2011 05:29 PM |
How do I type on multiple pics? | TimHudson | Drawing and Graphics | 0 | 07-28-2011 10:28 AM |