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,


Related:

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
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.
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"))
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!
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..

Similar discussions

Percentage calculation
dany -
m.thenmozhi -

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

2 responses
Percentage Work
Winndixie -
RayH -

6 responses
Excel Formula
bicky@7 -
bicky@7 -

6 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response