If error formula

[michmat120]

I have a worksheet that tracks test results. In column E, the score of a test will be calculated and shown as a %. This is the formula in the cells in column E. The score is entered into column D. The total marks possible for each test are located in column C.

=IF(OR(D31="",C31="")=TRUE,"",IF(OR(D31=0,C31=0)=TRUE,0,D31/C31))


So if Column C = 25, Column D = 25, then the formula will automatically calculate 100% in Column E.
If there is no score in Column D, then the cell in column E is blank.

Once in a while the test isn't actually scored, we may give it out as homework and we just check for completion. So in Column D, I want to be able to type something in like "complete" or "incomplete" and have column E remain blank or show a dash "-".

Is this possible? How would I modify the formula that I am currently using? Is there another option?

[etaf]

=IF(OR(D31="",C31=""),"",IF(OR(D31=0,C31=0),0,D31/C31))
change to
=IF(OR(D31="",C31="",D31="complete"),"",IF(OR(D31=0,C31=0),0,D31/C31))

[michmat120]

Thank you so much! That definitely works. Now what if the text in D31=incomplete instead of complete? Can that also be added to the formula?

[etaf]

=IF(OR(D31="",C31="",D31="complete",D31="incomplete"),"",IF(OR(D31=0,C31=0),0,D31/C31))

[michmat120]

Thank you!!! I had tried that but I must've missed something because it didn't work the first time. Now it does work and that's all that matters.

Michele

[etaf]

excellent

if my assistance has helped, and only if you wish to , there is a reputation icon * 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.

[michmat120]

I tried to find the reputation icon but couldn't locate it. What does it look like?
I also tried to mark the thread as solved but under Thread Tools, I only get 2 options: Show printable version and Subscribe to this thread.

What am I doing wrong?

[michmat120]

I found the answers...for some reason I keep having to refresh and log in again but even after doing so, I am not allowed to save my comments for reputation. I will try again.

[etaf]

Bottom of each post - left hand side

* add reputation