W
William Okumu
Hi I have the following
Category A1 A2 T1 T2
a 4 8 5 5
b 5 6 5 5
C 6 5 5 5
d 7 5 5 5
Total 22 23 20 20
A1 & A2 are Actual Qtr1 and Qtr2
T1 & T2 are Target Qtr1 and Qtr 2
I want a function to be in a cell eg A7 that will evaluate A1 by
comparing the individual category in A1 with T1 if the Individual
Category are >=T1 the it should Take The Total and mutiply it by 3%
which is this case should be 0.66 taking into account that Total
A1>=Total T1( if not then should return 0) but if any category in A1<T1
and Total A1>=Total T1then it should Take Total A1 multiply it by
2%(0.44).
In another Cell eg A8 we should have a function that evaluates if A7
divided by Total A1<3% if true then it should evaluate category
summation of each category A1 and A2 with summation of each Category T1
and T2 if (A1+A2)>=(T1+T2) then it should Take (Total A1+Total A2)*3%
minus Cell A7.And if A7 divided by Total A1=3% then it should evaluate
A2 by comparing the individual category in A2 with T2 if the Individual
Category are >=T2 then it should Take The Total A2 and mutiply it by 3%
which is this case should be 0.69 taking into account that Total
A2>=Total T2( if not then should return 0) but if any category in A2<T2
and Total A2>=Total T2then it should Take Total A2 multiply it by
2%(0.46).
Category A1 A2 T1 T2
a 4 8 5 5
b 5 6 5 5
C 6 5 5 5
d 7 5 5 5
Total 22 23 20 20
A1 & A2 are Actual Qtr1 and Qtr2
T1 & T2 are Target Qtr1 and Qtr 2
I want a function to be in a cell eg A7 that will evaluate A1 by
comparing the individual category in A1 with T1 if the Individual
Category are >=T1 the it should Take The Total and mutiply it by 3%
which is this case should be 0.66 taking into account that Total
A1>=Total T1( if not then should return 0) but if any category in A1<T1
and Total A1>=Total T1then it should Take Total A1 multiply it by
2%(0.44).
In another Cell eg A8 we should have a function that evaluates if A7
divided by Total A1<3% if true then it should evaluate category
summation of each category A1 and A2 with summation of each Category T1
and T2 if (A1+A2)>=(T1+T2) then it should Take (Total A1+Total A2)*3%
minus Cell A7.And if A7 divided by Total A1=3% then it should evaluate
A2 by comparing the individual category in A2 with T2 if the Individual
Category are >=T2 then it should Take The Total A2 and mutiply it by 3%
which is this case should be 0.69 taking into account that Total
A2>=Total T2( if not then should return 0) but if any category in A2<T2
and Total A2>=Total T2then it should Take Total A2 multiply it by
2%(0.46).