formula returns (correctly) a negative value
 

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?

=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?

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


"Anne Troy" wrote:

=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?

=MAX(0,AE193*0.15)

--
HTH

Bob Phillips

"brit64" wrote in message
...
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


"Anne Troy" wrote:

=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?

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'.


"Anne Troy" wrote:

=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?

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

--
HTH

Bob Phillips

"brit64" wrote in message
...
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'.


"Anne Troy" wrote:

=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?