D
Dpocahontas
Hi All: I have this formula which calculates the target achievement fo
a month based on the Net Actual/Net Plan. The below formula has a goo
thing as it takes into consideration that even when the plan is negativ
(as there is this weird plan now with the crisis), but the net actual i
positive it calculates it as positive achievement
=IF(AND(COUNT(I79,I80)=2,I80<0),I81/I80,+I79/I80) Now the table is a
per below:
=IF(AND(COUNT(I79,I80)=2,I80<0),I81/I80,+I79/I80
=IF(AND(COUNT(I53,I54)=2,I54<0),I55/I54,+I53/I54) - this formula is use
for Monthly Target Achievement % while for the up to date targe
achievement % I use =SUM($C$79:I79)/SUM($C$80:I80) and it gives in Jul
realization -101.53% which is not correct according to my needs. Now yo
help is , can I make the above formula = if(and(count(sum and make th
sum of months from January to July for each cell ....I try to do it bu
it gives an error of parenthesis and it or check your formula!! any hel
please! I hope is clear, sorry if not! but numbers are not so easy t
explain for me! thank yo
+-------------------------------------------------------------------
|Filename: Book2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=545
+-------------------------------------------------------------------
a month based on the Net Actual/Net Plan. The below formula has a goo
thing as it takes into consideration that even when the plan is negativ
(as there is this weird plan now with the crisis), but the net actual i
positive it calculates it as positive achievement
=IF(AND(COUNT(I79,I80)=2,I80<0),I81/I80,+I79/I80) Now the table is a
per below:
=IF(AND(COUNT(I79,I80)=2,I80<0),I81/I80,+I79/I80
=IF(AND(COUNT(I53,I54)=2,I54<0),I55/I54,+I53/I54) - this formula is use
for Monthly Target Achievement % while for the up to date targe
achievement % I use =SUM($C$79:I79)/SUM($C$80:I80) and it gives in Jul
realization -101.53% which is not correct according to my needs. Now yo
help is , can I make the above formula = if(and(count(sum and make th
sum of months from January to July for each cell ....I try to do it bu
it gives an error of parenthesis and it or check your formula!! any hel
please! I hope is clear, sorry if not! but numbers are not so easy t
explain for me! thank yo
+-------------------------------------------------------------------
|Filename: Book2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=545
+-------------------------------------------------------------------