Hard to title this post, but the issue is as follows:
I have three cells (A1,B1,C1) with scores and a fourth (D1) with the totals.
Cell D1 contains the formula: =(A1* .25) + (B1* .25) + (C1* .5). Simple enough.
However, the requirement is if either A1 or B1 does not contain a score, then the value in A1 or B1 needs to be multiplied by .50 instead of .25. For example, if A1 is null then B1*.50.
Finally, if A1 and B1 are both null, the total will only be calculated using C1, which will always have a score.
I have attached an image of this for reference. Looking for the cleanest way to do this with formulas. VBA is not my strong game but I'd be willing to thrash through it if it works better.
Thanks Folks.
Mikey
I have three cells (A1,B1,C1) with scores and a fourth (D1) with the totals.
Cell D1 contains the formula: =(A1* .25) + (B1* .25) + (C1* .5). Simple enough.
However, the requirement is if either A1 or B1 does not contain a score, then the value in A1 or B1 needs to be multiplied by .50 instead of .25. For example, if A1 is null then B1*.50.
Finally, if A1 and B1 are both null, the total will only be calculated using C1, which will always have a score.
I have attached an image of this for reference. Looking for the cleanest way to do this with formulas. VBA is not my strong game but I'd be willing to thrash through it if it works better.
Thanks Folks.
Mikey