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