| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help needed | Excel Discussion (Misc queries) | |||
| Appropriate formula needed! | Excel Discussion (Misc queries) | |||
| Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
| Formula needed | Excel Worksheet Functions | |||
| Formula needed | Excel Worksheet Functions | |||
![Fergal[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
