Calculation with a Blank or 0 Cell
Hi Planko,
Am Thu, 12 Jul 2012 16:13:32 +0000 schrieb Planko:
=IFERROR(('Page 1'!I45+'Page 1'!F45)/2,"N/A")
Hi all,
The above formula is what I need help with. I get the figure I want but
the problem is that 'Page 1'!F45 might not have a percentage in it to
calculate the total. So if I45 has 100% in it and F45 is 0%, or blank,
then I get 50% for my total. I need it to say 100% if the second
calculation is 0% or blank. The second calculation might not need to
have anything in it to figure the numbers needed. If there is a
calculation in F45 the formula works just fine.
try:
=IF('Page 1'!F45=0,'Page 1'!I45,AVERAGE('Page 1'!F45,'Page 1'!I45))
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|