Formula

Hi

I was wondering if someone would be able to please help me with a formula.
I am wanting to say:
if the answer is 8 subtract 3
if the answer is 6 subtract 2
if the answer is 4 subtract 1
if the answer is 2 subtract 0
if the answer is 1 subtract 0

thank you

Hi Janimen,

I don´t know if what I prepared for you is what you want but with the information you gave this is the way to do it.

ANSWER + IF(ANSWER=8,-3) + IF(ANSWER=6,-2) + IF(ANSWER=4,-1)

Find attached screenshots about how it is implemented in iDoceo.

 

 

Thank you for that, however it was not giving me the correct data,  I was also needing to change what I was needing it to do, as I had forgotten a few number from previous.

This is what I am needing it to say: NOTE:  I have 4 column that add to a total column.
IF total = 8 or 7 then the answer is 5
IF total = 6 or 5then the answer is 4
IF total = 4 or 3 then the answer is 3
IF total = 2 or 1 then the answer is 2
IF total = 0 then the answer is 1

Thank you once again

Hi Janimen,

You added more numbers now, if those are the numbers perhaps the best solution is to create a conversion table, like yours.
This can be done in Menu >  Grade Types > new grade > Grade Conversion.
I already did it for you , so attached you can find the Grade type called Janimen, drag and drop this template on your iDoceo and that´s it.
Once the grade type is in your iDoceo , use it as the selected grade type in the Answers column.
Now when you insert the points, the conversion is made on the fly.

Best regards
Karla

 
 
 

 

Thank you so much for that.  I do have a question how would I use that in a folder column?

Hi again ,

You create the column to receive the points as a simple column of 8 points , and then you assign the Janimen grade to the folder.

Check out my image

Best regards
Karla