Calculation with a Blank or 0 Cell

[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 bu
the problem is that 'Page 1'!F45 might not have a percentage in it t
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 secon
calculation is 0% or blank. The second calculation might not need t
have anything in it to figure the numbers needed. If there is
calculation in F45 the formula works just fine.

Thanks for any help,

Plank

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

=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 bu
the problem is that 'Page 1'!F45 might not have a percentage in it t
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 secon
calculation is 0% or blank. The second calculation might not need t
have anything in it to figure the numbers needed. If there is
calculation in F45 the formula works just fine.

Thanks for any help,

Planko

Hi Planko,

You need IF statements in there to do this. It would be easier to sho
you how if you could post an example workbook.

S

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

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

 

[Planko]

Hi Planko,

Am Thu, 12 Jul 2012 16:13:32 +0000 schrieb Planko:
-

try:
=IF('Page 1'!F45=0,'Page 1'!I45,AVERAGE('Page 1'!F45,'Page 1'!I45))


Regards
Claus Busch

Claus,

Thanks! That work perfectly. I really appreciate it.

Let say I had three columns now with the same formula. Maybe one or tw
columns out of the three had inputted information. The others do not.

I have tried myself and cannot figure it out.

Plank

+-------------------------------------------------------------------
+-------------------------------------------------------------------