View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brown_toby
 
Posts: n/a
Default Roundup Function


I am having a problem with the following function:

=ROUNDUP((C5*C4),2)

Upon entering the above the cell shows: "#VALUE!" when cell C4 is
empty. I would like it to show zero when cell C4 is empty.


--
brown_toby
------------------------------------------------------------------------
brown_toby's Profile: http://www.excelforum.com/member.php...o&userid=35942
View this thread: http://www.excelforum.com/showthread...hreadid=557416