Formula needed please...

[Fergal]

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.

 

[Billy Liddel]

Fergal

try =SUM(A1:A3)*0.2

Peter

 

[Bernard Liengme]

=SUM(A1:A3)*20%
best wishes

 

[Fergal]

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

 

[Fergal]

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