Joe
=IF(J7<=0,0,J7*0.15)
Gord Dibben Excel MVP
On Thu, 1 Jan 2004 12:04:05 -0600, huhnjoe
wrote:
I have created a soreadsheet with a field called 'Less 15% Reserve'. I
want it to calculate the 15% amount based only if a positive number
appears in the cell used for calculation, not if that amount is a
negative amount. How do I create the formula that would leave the cell
at a '0' if in fact the calculator cell is a negative number?
Please help!
Thanks & Happy New Year
Joe
Attachment filename: summary log.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=394790
---
Message posted from http://www.ExcelForum.com/