Thread: [Solved] Calculating the “total” based on “salary” value and its “type” (multiple IF),
View Single Post
 
Old 07-04-2016, 08:26 PM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question 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
Attached Images
File Type: jpg Clip_400.jpg (117.8 KB, 17 views)
Attached Files
File Type: xlsx Type_Factor_Value_Total.xlsx (8.7 KB, 10 views)
Reply With Quote