Need help with an Calculation result
 

Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. However, when I have no values in H32 or H50 the result is
obviously a zero(0).

My question is this: How can I make the result show up as blank on the
other page and not show as a zero(0)?

Need help with an Calculation result
 

=IF(SUM(H32,H50)<0,SUM(H32,H50)/20,"")
Regards,
Alan.
"rapierguy" wrote in message
...
Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. However, when I have no values in H32 or H50 the result
is
obviously a zero(0).

My question is this: How can I make the result show up as blank on the
other page and not show as a zero(0)?

Need help with an Calculation result
 

Try this:

=IF(H32+H50,(H32+H50)/20,"")

--
Biff
Microsoft Excel MVP


"rapierguy" wrote in message
...
Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. However, when I have no values in H32 or H50 the result
is
obviously a zero(0).

My question is this: How can I make the result show up as blank on the
other page and not show as a zero(0)?

Need help with an Calculation result
 

Hi

=IF(AND(ISBLANK(H32),ISBLANK(H50)),"",SUM(H32,H50)/20)

Regards,
Per

On 12 Apr., 03:33, rapierguy
wrote:
Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. *However, when I have no values in H32 or H50 the result is
obviously a zero(0).

My question is this: *How can I make the result show up as blank on the
other page and not show as a zero(0)?

Need help with an Calculation result
 

Alan, T. Valko and Per Jessen,

I tried all your solutions but I get a "#NAME?" error. Any ideas?

"Per Jessen" wrote:

Hi

=IF(AND(ISBLANK(H32),ISBLANK(H50)),"",SUM(H32,H50)/20)

Regards,
Per

On 12 Apr., 03:33, rapierguy
wrote:
Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. However, when I have no values in H32 or H50 the result is
obviously a zero(0).

My question is this: How can I make the result show up as blank on the
other page and not show as a zero(0)?

Need help with an Calculation result
 

Post the *exact* formula that is giving you that error.

--
Biff
Microsoft Excel MVP


"rapierguy" wrote in message
...
Alan, T. Valko and Per Jessen,

I tried all your solutions but I get a "#NAME?" error. Any ideas?

"Per Jessen" wrote:

Hi

=IF(AND(ISBLANK(H32),ISBLANK(H50)),"",SUM(H32,H50)/20)

Regards,
Per

On 12 Apr., 03:33, rapierguy
wrote:
Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. However, when I have no values in H32 or H50 the
result is
obviously a zero(0).

My question is this: How can I make the result show up as blank on the
other page and not show as a zero(0)?

Need help with an Calculation result
 

Not sure what I did, but I managed to figure it out.
What I wound up doing was this:

=SUM(H32,H50)/20

I then placed the result in a cell and called the cell "Academic" (minus the
quotes)

Then on another page I did the following

=IF((Academic=0),"",(Academic))

And now I have a blank in the cell I wanted.


"T. Valko" wrote:

Post the *exact* formula that is giving you that error.

--
Biff
Microsoft Excel MVP


"rapierguy" wrote in message
...
Alan, T. Valko and Per Jessen,

I tried all your solutions but I get a "#NAME?" error. Any ideas?

"Per Jessen" wrote:

Hi

=IF(AND(ISBLANK(H32),ISBLANK(H50)),"",SUM(H32,H50)/20)

Regards,
Per

On 12 Apr., 03:33, rapierguy
wrote:
Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. However, when I have no values in H32 or H50 the
result is
obviously a zero(0).

My question is this: How can I make the result show up as blank on the
other page and not show as a zero(0)?

Need help with an Calculation result
 

Ok, glad to see you got it working.

=IF((Academic=0),"",(Academic))

You don't need the extra ( ):

=IF(Academic=0,"",Academic)

--
Biff
Microsoft Excel MVP


"rapierguy" wrote in message
...
Not sure what I did, but I managed to figure it out.
What I wound up doing was this:

=SUM(H32,H50)/20

I then placed the result in a cell and called the cell "Academic" (minus
the
quotes)

Then on another page I did the following

=IF((Academic=0),"",(Academic))

And now I have a blank in the cell I wanted.


"T. Valko" wrote:

Post the *exact* formula that is giving you that error.

--
Biff
Microsoft Excel MVP


"rapierguy" wrote in message
...
Alan, T. Valko and Per Jessen,

I tried all your solutions but I get a "#NAME?" error. Any ideas?

"Per Jessen" wrote:

Hi

=IF(AND(ISBLANK(H32),ISBLANK(H50)),"",SUM(H32,H50)/20)

Regards,
Per

On 12 Apr., 03:33, rapierguy
wrote:
Trying to do something along the lines of the following:

=SUM(H32,H50)/20

then have the result show up on another page.

This works fine. However, when I have no values in H32 or H50 the
result is
obviously a zero(0).

My question is this: How can I make the result show up as blank on
the
other page and not show as a zero(0)?