weighted averages from different columns

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?