- Thank you received: 0
Formula
- Janinem
- Topic Author
- Offline
Less
More
1 year 2 days 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
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
- Ruislip
- Offline
Less
More
- Thank you received: 29
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
1 year 1 day 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
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
- Ruislip
- Offline
Less
More
- Thank you received: 29
1 year 1 day 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
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
Attachments:
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
- Ruislip
- Offline
Less
More
- Thank you received: 29