Formula

More
8 months 2 weeks ago #31112 by Janinem
Formula was created by Janinem
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

Please Log in or Create an account to join the conversation.

More
8 months 2 weeks ago #31113 by Ruislip
Replied by Ruislip on topic Formula
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.

 

 
Attachments:

Please Log in or Create an account to join the conversation.

More
8 months 1 week ago #31115 by Janinem
Replied by Janinem on topic Formula
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

Please Log in or Create an account to join the conversation.

More
8 months 1 week ago #31116 by Ruislip
Replied by Ruislip on topic Formula
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

 

File Attachment:

File Name: iDoceo__Gr...e.idoceo
File Size:0 KB

 
 

 
Attachments:

Please Log in or Create an account to join the conversation.

More
8 months 1 week ago #31117 by Janinem
Replied by Janinem on topic Formula
Thank you so much for that.  I do have a question how would I use that in a folder column?
Attachments:

Please Log in or Create an account to join the conversation.

More
8 months 1 week ago #31118 by Ruislip
Replied by Ruislip on topic Formula
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
 
Attachments:

Please Log in or Create an account to join the conversation.