Thank you. I will continue to play over the next few days, and will get back to you with any issues or questions.

Hello again. I am having an issue with the total grade within the responding tab. Most of the values have totaled correctly however there are a few, where values have been entered into tab D and E and nothing in the rest, the grade that has been calculated as an A, where is clearly needs to be an E, not sure where I have gone wrong. Happy to email it again, if you don't mind looking into it

Sorry another one, but it seems like the converstion I have is not calculating correctly. This is what I have:
A 90%
B 70%
C 50%
D 49%
E 24%

My uncderstanding if that if any value if above this then that grade will apply, however I have columns where 25 is an A, 18 is a B, 43 is a B, 68 is an A, and there are a few more.

What am I doing wrong

So I think this is happening because there is no value in the main columns , Is there a way that I can say if there is no data in the cell to either put a 0 or ignore

Hello Janinem,

I am Munay from iDoceo support, I have read your comments and will like to help you set up your iDoceo as you need it.

Please send me a template of you class, so I can see exactly what you have now and how it is configured and also attach some screenshot as well, so I can reproduce what you are experiencing.

With that I will be able to know what is happening and advice what you need to correct or change to obtain the results you need.

You can send the template to karla.idoceolabs @ gmail.com

When creating the template make sure to have the option Gradebook and Include all tabs selected, as in the image I am attaching here.

So I have managed to sort that out, can anyone help with a code that allows me to do the following.

There are 3 cells in the row, with a total point value of 3:
I still want to add cell 1 + 2+3 together to get a result
However I also want to say that if cell 1 and 3 = 2 return a result of 3

Each cell only gets a value of either 1 or 0

I hope this makes sense

It would look like this:
If the condition is met, yields a 3 (first section after condition) , if not (second section after condition) CELL1 + CELL2 + CELL3

ok, so going back to the email I sent the other day, if I added a new column into C, There is the overall value and the 3 tabs within.
what I am trying to do is say:
if [1C with added column + Q1B 3 correct(even thought the result is 2) return a result of 3 (in the overall column- green)
as well as saying that if [1C no assed response + Q1B 3 correct(even thought the result is 2) return a result of 2.

I would also like to be able to say that if there is a value of 1 in either of the columns with the other being 0 then return a 1.

Sorry, this sounds better in my head, hard to try and explain what I am wanting to do

I guess what I am trying to achieve is (looking at C-green and the columns within that)
if there is only a 1 in one of the columns they get a score of 1.
if there is a 1 in column 2 and 3 they get a score of 2.
if there is a 1 in column 1 and 3 they get a score of 3

Is it possible for Column 1 and Column 2 to hold a 1 and column 3 a 0?

no it is not - it is basically either column 1 or 2 but not both

A sort of table of truth of that formula would look like this.

There are three sections in it, separated by a + sign.
The first one counts the number of 1s in C1,C2,C3. If the number of 1s equals 1, then yields a 1
The second section, takes into account C2 and C3' condition
The third section, takes into account C1 and C3' condition





There is probably a more elegant solution to this formula but I did not have my morning coffee yet and this one is hopefully easier to follow.
Let me know if it works for you. Just be careful with the parentheses.

Yay that has seemed to do the trick. Thank you thank you thank you.