formula returns (correctly) a negative value

[Guest]

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?

 

[Anne Troy]

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

 

[Guest]

Anne thank you very much, am now close to resolving my issue for this
spreadsheet. While your solution did indeed correct the result in the cell
198, it posed yet another unresolved dilemma in a different cell. Am studying
that issue right now and will no doubt pose a second question here when I can
formulate it correctly.
peter
tucson, arizona

 

[Bob Phillips]

=MAX(0,AE193*0.15)

--
HTH

Bob Phillips

Anne thank you very much, am now close to resolving my issue for this
spreadsheet. While your solution did indeed correct the result in the cell
198, it posed yet another unresolved dilemma in a different cell. Am studying
that issue right now and will no doubt pose a second question here when I can
formulate it correctly.
peter
tucson, arizona

 

[Guest]

many thanks Anne, this answer takes me on to:
Problem #2 in cell AF201 (repeated in cells AG191 & AG193)
Current formula in cell AF201:
=SUM(AE185*AD201)
However, I want the result displayed in this cell AF201 to be 0.00 IF cell
AE187 is a negative number. On the other hand if cell AE187 is a positive
number, then the result in cell AF201 should be displayed normally (i.e.
ignoring the command to display a result of 0.00 when cell AE187 is a
negative number).

in other words I believe I am looking for a command prefix for 'UNLESS'.

 

[Bob Phillips]

=IF(AE187<0,0,MAX(0,AE185*0.15))