I already have my data entered on the spreadsheet. I need to know a formula
that would give me a percentage of each row or column. Any help would be
greatly appreciated!
Thanks,
Meagan
The formula for a percentage is =part/whole. If your data is in column A
with a SUM in cell A10, you could put this formula in B1 =A1/A$10. Then
format the cell as a percentage. This formula could then be filled down
column B to do the same calculation for the rest of the rows.
Carlos
"MeaganNW" <MeaganNW@discussions.microsoft.com> wrote in message
news:76281B47-E35A-47E8-92DA-21414BBC0165@microsoft.com...
> I already have my data entered on the spreadsheet. I need to know a
formula
> that would give me a percentage of each row or column. Any help would be
> greatly appreciated!
> Thanks,
> Meagan
> I already have my data entered on the spreadsheet. I need to know a formula
> that would give me a percentage of each row or column. Any help would be
> greatly appreciated!
> Thanks,
> Meagan
> I already have my data entered on the spreadsheet. I need to know a formula
> that would give me a percentage of each row or column. Any help would be
> greatly appreciated!
> Thanks,
> Meagan
Assuming your data are in A1:A10, you could use a formula like:
=A1/SUM(A$1:A$10)
in B1 and copy down to B10.
Alternatively, if you've got a total in A11, you could use a formula like:
=A1/A$11
in B1 and copy down to B10.
in either case, format the cells as %.
--
Cheers
macropod
[MVP - Microsoft Word]
"sads" <sads@discussions.microsoft.com> wrote in message news:2A495075-8A31-425C-B69F-C008FD4DAC77@microsoft.com...
>
>
> "MeaganNW" wrote:
>
>> I already have my data entered on the spreadsheet. I need to know a formula
>> that would give me a percentage of each row or column. Any help would be
>> greatly appreciated!
>> Thanks,
>> Meagan
Question
Reply
Top
Answer
Notify me of replies