Percentages

I have worked out percentages, but want my total to include a different cell:
example I have starting figure in cell A1, iA2 is total is minus 50% of A1,
A3 is total of A2 minus 10% of A2, I now want A4 to equal A3 minus 10% of A1,
How do I achieve this?

Seems simple with what you have so maybe I don't understand, but

=A1*90%

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Hotpants0063" <[email protected]> wrote in message
news:[email protected]...
> I have worked out percentages, but want my total to include a different
cell:
> example I have starting figure in cell A1, iA2 is total is minus 50% of
A1,
> A3 is total of A2 minus 10% of A2, I now want A4 to equal A3 minus 10% of
A1,
> How do I achieve this?

Not quite.

Hotpants, try =A3(A1*90%) in cell A4.

"Bob Phillips" wrote:

> Seems simple with what you have so maybe I don't understand, but
>
> =A1*90%
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Hotpants0063" <[email protected]> wrote in message
> news:[email protected]...
> > I have worked out percentages, but want my total to include a different
> cell:
> > example I have starting figure in cell A1, iA2 is total is minus 50% of
> A1,
> > A3 is total of A2 minus 10% of A2, I now want A4 to equal A3 minus 10% of
> A1,
> > How do I achieve this?
>
>
>

Ooops!

=A3-(A1*90%)

"Lowkey" wrote:

> Not quite.
>
> Hotpants, try =A3(A1*90%) in cell A4.
>
> "Bob Phillips" wrote:
>
> > Seems simple with what you have so maybe I don't understand, but
> >
> > =A1*90%
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Hotpants0063" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have worked out percentages, but want my total to include a different
> > cell:
> > > example I have starting figure in cell A1, iA2 is total is minus 50% of
> > A1,
> > > A3 is total of A2 minus 10% of A2, I now want A4 to equal A3 minus 10% of
> > A1,
> > > How do I achieve this?
> >
> >
> >

Thanks all for the help,,,but after trying your formula of A1*90%, i realised
that it should have been A1*10%,,,and it worked,,,
--
Katy


"Lowkey" wrote:

> Ooops!
>
> =A3-(A1*90%)
>
> "Lowkey" wrote:
>
> > Not quite.
> >
> > Hotpants, try =A3(A1*90%) in cell A4.
> >
> > "Bob Phillips" wrote:
> >
> > > Seems simple with what you have so maybe I don't understand, but
> > >
> > > =A1*90%
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from email address if mailing direct)
> > >
> > > "Hotpants0063" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I have worked out percentages, but want my total to include a different
> > > cell:
> > > > example I have starting figure in cell A1, iA2 is total is minus 50% of
> > > A1,
> > > > A3 is total of A2 minus 10% of A2, I now want A4 to equal A3 minus 10% of
> > > A1,
> > > > How do I achieve this?
> > >
> > >
> > >