Need help with Percentage Please

[Solved/Closed]
Report
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
try this

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

format your cell as Percentage
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013

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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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"))
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013

That did it! Awesome job! Thank you very much Riz!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You are welcome TarExcel
Live Long and Prosper..