|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
07-04-2016, 08:26 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode