lgbtq-plus

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

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

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?")

bigger question bopit

how does one check if a row of sells contains "EX"

you might want to have the error at the end be "ERROR"

so it returns text btw

if you sum with that

it ignores the text

=IF(D2:I2="EX", 250, 0) doesnt work :(

You know guys

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

ok

so

in excel

for your error

you would do

Since I feel bad about yelling at you for 90% of my conversation in here

ctrl+shit+enter

I drew you an image

when you use the formula

which creates an array

idk if that works for sheets

This is the official art for this channel now

no its not

go away

see rusp

you can take my job

Ikr

didn't even give the bipen a tail

Look at the catfish

It’s so realistic

you've been

neutered bopit

fuck