lgbtq-plus

yes

dan can you count

how many )s i need

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

"E"

b/c

dumb reasons

?

wdym

I always forget the "

oh

i was about to ask

if i need "

yeah it's text

so it's retarded how it reads it

ia ssumed i needed it at first

yeah my bad I rarely use text values so I'm not used to having "

=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)))))))))))))))))))))

it works

ayy

pog

so A+++ and EX have the same value?

thats an error

i was gona make it 250

lol

actually

for this method

since i want a uh

EXless and EX full value

ill make it set EX to "EX"

so when I sum it all

i can get that

might be better to have EX return 0 so it will not fuck with the sum formula

so max

what are you going to do with ranges

Ignoring EX

https://i.imgur.com/b7o8XGn.png

gonna make them their max I suppose

now bopit

how do i make a sum

ignore errors

let me try something

i figured it out

=SUMIF(D2:I2,"<>#NAME?")