lgbtq-plus

thats the true question

unsure

or I could do it manually

for 300 servants

i think the + would fuck it up

but i dont know

are you around

lord of spreadsheets

hes fucking dead

you want

C+

to return a numerical value?

okay bopit

are you good with spreadsheets

if statement

if(C+, #)

if you want to do it for all of them

you would chain the if statments

which could be a pain

if(C+, #, if(B-, #, etc))

that's the best way I know how to do it

does that answer your question or were you trying to do something else?

Sheet1!D2=IF(E, 10, IF(E+, 20

and keep chaining?

yes

okay.

then close with a lot

of )s?

or

it's a pain but I think that's the only way to do it

yes

close with

a LOT

of )

nice thing is

you should only have to do it once

then you can copy it down

yes

dan can you count

21

actually

yeah that sounds righth

tbh if you entered it

and let sheets correct you

it will probably fix it for you

oh

and

for the last if

you might want to write it like

if(EX, #, ERROR)

Why are you doing this

so you know if you fucked up with the letter

and so you can check to see that it goes to the end of the if chain

The entire spreadsheet

I mean

Ah

I see

Sheet1!D2=IF(E, 10, IF(E+, 20, IF(E++, 30, IF(E+++, 40, IF(D, 20, IF(D+, 40, IF(D++, 60, IF(D+++, 80, IF(C, 30, IF(C+, 60, IF(C++, 90, IF(C+++, 120, IF(B, 40, IF(B+, 80, IF(B++, 120, IF(B+++, 160, IF(A, 50, IF(A+, 100, IF(A++, 150, IF(A+++, 200, IF(EX, 200, ERROR)))))))))))))))))))))

looks good to me

okay it no work

is it too long

or did i not close something

let me look

oh wait

bruh

ok

I fucked up, it's =IF(Sheet1!D2 = E, 10, IF(

so all you need to do

it put a Sheet1!D2 =

in front of all the letters

sorry about that

=IF(Sheet1!D2=E, 10, IF(Sheet1!D2=E+, 20, IF(Sheet1!D2=E++, 30, IF(Sheet1!D2=E+++, 40, IF(Sheet1!D2=D, 20, IF(Sheet1!D2=D+, 40, IF(Sheet1!D2=D++, 60, IF(Sheet1!D2=D+++, 80, IF(Sheet1!D2=C, 30, IF(Sheet1!D2=C+, 60, IF(Sheet1!D2=C++, 90, IF(Sheet1!D2=C+++, 120, IF(Sheet1!D2=B, 40, IF(Sheet1!D2=B+, 80, IF(Sheet1!D2=B++, 120, IF(Sheet1!D2=B+++, 160, IF(Sheet1!D2=A, 50, IF(Sheet1!D2=A+, 100, IF(Sheet1!D2=A++, 150, IF(Sheet1!D2=A+++, 200, IF(Sheet1!D2=EX, 200, ERROR)))))))))))))))))))))

like that?

should be right let me double check

oh

and you need

should i perhaps

"E"

b/c