Thread: negative value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
huhnjoe huhnjoe is offline
external usenet poster
 
Posts: 1
Default negative value

I have created a soreadsheet with a field called 'Less 15% Reserve'.
want it to calculate the 15% amount based only if a positive numbe
appears in the cell used for calculation, not if that amount is
negative amount. How do I create the formula that would leave the cel
at a '0' if in fact the calculator cell is a negative number?

Please help!

Thanks & Happy New Year

Jo

Attachment filename: summary log.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39479
--
Message posted from http://www.ExcelForum.com