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)?
|