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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 9, 2013 at 12:42 PM
Related:
- 75 paise interest means how much percentage
- Excel marksheet percentage formula - Guide
- How to check battery percentage on ps4 controller - Guide
- Calculator percentage - Office Software Forum
- Percentage conversion in excel - Excel Forum
- Chrome custom zoom percentage - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 8, 2013 at 10:45 AM
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
=IF(OR(A1="",B1=""),"",IF(B1<>0,A1/B1,"Error Divide by Zero"))
format your cell as Percentage
TarExcel
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
Mar 8, 2013 at 03:46 PM
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.
=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
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"))
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
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
Mar 9, 2013 at 12:42 PM
You are welcome TarExcel
Live Long and Prosper..
Live Long and Prosper..