# Formula

10 months 2 weeks ago #31112 by Janinem
Formula was created by Janinem
Hi

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
10 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.

Find attached screenshots about how it is implemented in iDoceo.

##### Attachments:
10 months 2 weeks 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
10 months 2 weeks 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.
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.
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:
10 months 2 weeks 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:
10 months 2 weeks 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