Previous Topic Next Topic

Need help with Percentage Please

Solved/Closed
TarExcel Posts 3 Registration date Thursday March 7, 2013 Status Member Last seen March 9, 2013 - Mar 7, 2013 at 05:09 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 9, 2013 at 12:42 PM
Hello,

I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason other than to help. I just wrote a post that a Mod deleted because I didn't say thank you anywhere in it. I'll make sure to save the massage before I post now. I need to get a percentage to fill in a cell, and i'm unable to figure it out myself.

I don't know if this will line up, I don't remember how I had it before.

A ----- B --- C ----- D
Total Win Lose Percent
10 --- 7 --- 3 ----- 70%

I wanted D to fill with the percentage of B from A. Or add B+C=D. I'm not sure how to get it to fill. Thanks you anyone who could help me.

Thanks all,


2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 8, 2013 at 10:45 AM
try this

=IF(OR(A1="",B1=""),"",IF(B1<>0,A1/B1,"Error Divide by Zero"))

format your cell as Percentage
0
Answer 2 / 2
TarExcel Posts 3 Registration date Thursday March 7, 2013 Status Member Last seen March 9, 2013
Mar 8, 2013 at 03:46 PM
Very Close! Thank you for the try and you may be able to very easily figure out what went wrong. I tried to figure it out by switching cells and the orders of the formula, but to no avail.

=IF(OR(A1="",B1=""),"",IF(B1<>0,A1/B1,"Error Divide by Zero"))

These are the actual values if that matters.
=IF(OR(B11="",C11=""),"",IF(C11<>0,B11/C11,"Error Divide by Zero"))

With this formula D comes out like this.

A ----- B --- C ----- D
Total Win Lose Percent
22 --- 11 --11 ---- 200%

Ill keep trying myself, Thanks again.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 9, 2013 at 08:37 AM
I had cells different from your example
A ----- B --- C ----- D
Total Win Lose Percent
10 --- 7 --- 3 ----- 70%

this is as per your example

=IF(OR(A1="",B1=""),"",IF(A1<>0,B1/A1,"Error Divide by Zero"))
0
TarExcel Posts 3 Registration date Thursday March 7, 2013 Status Member Last seen March 9, 2013
Mar 9, 2013 at 11:35 AM
That did it! Awesome job! Thank you very much Riz!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 9, 2013 at 12:42 PM
You are welcome TarExcel
Live Long and Prosper..
0

Similar discussions

Percentage calculation
dany -
m.thenmozhi -

2 responses
Percentage Work
Winndixie -
RayH -

6 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
Excel Formula
bicky@7 -
bicky@7 -

6 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response