| Posted By |
Message |
kerrycec03
Mom of 2 beautiful boys!!
Member since 6/06 13519 total posts
Name:
Kerry
|
URGENT EXCEL QUESTION
Ok, how do I do 65% of a cell? Like if the cell has $100, how to represent 65% of that in another cell? I've been trying everything.
Thanks
|
Posted 10/18/07 4:19 PM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
IrishMom77
Brothers!!
Member since 8/05 3498 total posts
Name:
Roseann
|
Re: URGENT EXCEL QUESTION
try this
a4 would represent the 100
=(65/A4)*100
|
| Posted 10/18/07 4:21 PM |
| |
|
TeamSweet
LIF Adolescent
Member since 5/07 834 total posts
Name:
Heather
|
Re: URGENT EXCEL QUESTION
I always use the "help" in excel when I can't remember how to do a formula. Type in percentage formula or something like that and it should come up how to do it. HTH!
|
| Posted 10/18/07 4:22 PM |
| |
|
bird382
.
Member since 7/07 1712 total posts
Name:
|
Re: URGENT EXCEL QUESTION
Posted by Tigger77
try this
a4 would represent the 100
=(65/A4)*100
yep, or multiply the original cell by 0.65
=[original cell]*.65
Message edited 10/18/2007 4:23:34 PM.
|
| Posted 10/18/07 4:22 PM |
| |
|
kerrycec03
Mom of 2 beautiful boys!!
Member since 6/06 13519 total posts
Name:
Kerry
|
Re: URGENT EXCEL QUESTION
Posted by bird382
Posted by Tigger77
try this
=[original cell]*.65
I tried this and it didn't work
|
| Posted 10/18/07 4:26 PM |
| |
|
bird382
.
Member since 7/07 1712 total posts
Name:
|
Re: URGENT EXCEL QUESTION
Weird, it works for me...
|
| Posted 10/18/07 4:29 PM |
| |
|
kerrycec03
Mom of 2 beautiful boys!!
Member since 6/06 13519 total posts
Name:
Kerry
|
Re: URGENT EXCEL QUESTION
I ended up doing them manually, what a PITA!!!! GRRR!!! I wonder if the slide was bummed up.
|
| Posted 10/18/07 4:44 PM |
| |
|
bird382
.
Member since 7/07 1712 total posts
Name:
|
Re: URGENT EXCEL QUESTION
Ugh, that stinks. Sorry! But at least you got it done.
|
| Posted 10/18/07 4:51 PM |
| |
|
BlueDiamonds
mommy to 3 boys
Member since 2/07 3885 total posts
Name:
proud mommy
|
Re: URGENT EXCEL QUESTION
Posted by bird382
Posted by Tigger77
try this
a4 would represent the 100
=(65/A4)*100
yep, or multiply the original cell by 0.65
=[original cell]*.65
i know you responded already that you did it manually, but this is what i was going to suggest. whenever i do % in excel, i always multiply the number by the decimal. so much easier. just wanted to add this so you know for the future.
|
| Posted 10/18/07 5:56 PM |
| |
|
