View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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)?