Formula needed please...
 

This is probably simple to you guys, but I can't seem to get it to work. I
need a formula that will add together the sum of A1, A2, & A3 cells, then
display (in A4) 20% of the total?
Hope this makes sense.
Many Thanks for any replies.

Formula needed please...
 

Fergal

try =SUM(A1:A3)*0.2

Peter

"Fergal" wrote:

This is probably simple to you guys, but I can't seem to get it to work. I
need a formula that will add together the sum of A1, A2, & A3 cells, then
display (in A4) 20% of the total?
Hope this makes sense.
Many Thanks for any replies.

Formula needed please...
 

=SUM(A1:A3)*20%
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fergal" wrote in message
...
This is probably simple to you guys, but I can't seem to get it to work. I
need a formula that will add together the sum of A1, A2, & A3 cells, then
display (in A4) 20% of the total?
Hope this makes sense.
Many Thanks for any replies.

Formula needed please...
 

Many Thanks to both Billy & Bernard for the prompt replies, but just to
complicate things further. What if the figures to be calculated where in A1
& B5?
Thank You

"Bernard Liengme" wrote in message
...
=SUM(A1:A3)*20%
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fergal" wrote in message
...
This is probably simple to you guys, but I can't seem to get it to work.
I need a formula that will add together the sum of A1, A2, & A3 cells,
then display (in A4) 20% of the total?
Hope this makes sense.
Many Thanks for any replies.

Formula needed please...
 

OK, I managed to do it,
Thank You for all your help.....

"Fergal" wrote in message
...
Many Thanks to both Billy & Bernard for the prompt replies, but just to
complicate things further. What if the figures to be calculated where in
A1 & B5?
Thank You

"Bernard Liengme" wrote in message
...
=SUM(A1:A3)*20%
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fergal" wrote in message
...
This is probably simple to you guys, but I can't seem to get it to work.
I need a formula that will add together the sum of A1, A2, & A3 cells,
then display (in A4) 20% of the total?
Hope this makes sense.
Many Thanks for any replies.