LinkBack URL
About LinkBacks
Hello,
I would like to find the percentage of accuracy between payment terms and the actual days paid. I'm getting errors when 0 is one or both of the divided terms.
Any assistance would be appreciated
Thank you very much
Hello,
I would like to find the percentage of accuracy between payment terms and the actual days paid. I'm getting errors when 0 is one or both of the divided terms.
Any assistance would be appreciated
Thank you very much
you will have to test for zero with an if or iferror or iserror
dont see the the calculation in your example or any errors - can you show the issues you are having on the sheet - so we know exactly what you are doing rather than assume
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
You not say which way round you are testing (I would use A/B), so maybe this...
If you only want the error removed...
=IF(A2=0,"",B2/A2)
or this if you want everything removed...
=IF(OR(A2=0,B2=0),"",B2/A2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello,
I have attached the zero results I am receiving. Ideally I would like to have the percentage calculated.
Thank you for your replies
0/number will return a Zero - so not an error
if you want the condition for either to be 0 use
FDibbins modified
=IF(OR(F2=0, G2=0), 1, F2/G2)
and format the column for %
That's great. Thank you so much
etaf, thanks for the assist
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks