=if(a3193<=0,0,AE193*0.15)
(You don't need that SUM bit...)
************
Anne Troy
www.OfficeArticles.com


"brit64" wrote in message
...
CELL AE198 displays 15% of cell AE193. My formula in cell AE198 is:
=SUM(AE193*0.15)
Whenever the value in cell AE193 is negative, i.e. less than 0.00, this
formula currently correctly returns a negative value which I do not want
to
show, rather whenever this formula (and cell AE193) are negative values,
I
want the formula in cell AE198 to display 0.00. Whenever cell AE193 and
the
formula show or return a positive value, then I want the formula to
continue
correctly displaying whatever that positive value may be. How must I
modify
my formula in order to achieve this desired objective?