Performing Calculations if Cell = ""

mwiggins

Hello Community, 

 

I have a question on what the optimal solution is to a calculation I would like to perform.

Here is what's there:

In one column I have job title - based on if that cell = "[title X,Y...]" then I'd like to perform a calculation based on four other columns that have calculated values in them - but the weight of those calculations will change based on what position is listed.

For instance, 

If they are Title X, then AVG(all scores), if they are Title Y, then AVG(scores 1-3)+(score 4 * 2)

 

Please let me know if this is possible or if I should go another route!

Thank you

Paul Newcome

Very possible. It could be rather drawn out depending on how many titles you have though.

 

=IF(Title@row = "X", AVG(Score1:Score4), IF(Title@row = "Y", AVG(Score1:Score3, Score4*2)))