Need help with Percentage Please Solved/Closed

Question

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,


Configuration: Windows 7 / Chrome 25.0.1364.97

rizvisa1 · Answer

try this 

=IF(OR(A1="",B1=""),"",IF(B1<>0,A1/B1,"Error Divide by Zero")) 

format your cell as Percentage

TarExcel · Answer

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.

Need help with Percentage Please

2 responses

Similar discussions

Subscribe To Our Newsletter!