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" <brit64@discussions.microsoft.com> wrote in message
news:32DE473D-C730-41D6-9263-9D973862C449@microsoft.com...
> 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" <brit64@discussions.microsoft.com> wrote in message
> news:32DE473D-C730-41D6-9263-9D973862C449@microsoft.com...
> > 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" <brit64@discussions.microsoft.com> wrote in message
news:7B1FB2ED-9ED8-4651-BFB1-FADFE3597BEB@microsoft.com...
> 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" <brit64@discussions.microsoft.com> wrote in message
> > news:32DE473D-C730-41D6-9263-9D973862C449@microsoft.com...
> > > 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" <brit64@discussions.microsoft.com> wrote in message
> news:32DE473D-C730-41D6-9263-9D973862C449@microsoft.com...
> > 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" <brit64@discussions.microsoft.com> wrote in message
news:44622CB0-BC28-4D7E-9025-16995CD72C28@microsoft.com...
> 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" <brit64@discussions.microsoft.com> wrote in message
> > news:32DE473D-C730-41D6-9263-9D973862C449@microsoft.com...
> > > 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?
> > >
> >
> >
> >