Message in #gacha · Kappa⁴ Archive

taxes May 12, 2020 1:11 AM gacha

gonna make them their max I suppose

taxes May 12, 2020 1:11 AM gacha

now bopit

taxes May 12, 2020 1:11 AM gacha

how do i make a sum

taxes May 12, 2020 1:11 AM gacha

ignore errors

Bopit May 12, 2020 1:13 AM gacha

let me try something

taxes May 12, 2020 1:13 AM gacha

i figured it out

taxes May 12, 2020 1:13 AM gacha

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

taxes May 12, 2020 1:14 AM gacha

bigger question bopit

taxes May 12, 2020 1:14 AM gacha

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

Bopit May 12, 2020 1:15 AM gacha

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

Bopit May 12, 2020 1:15 AM gacha

so it returns text btw

Bopit May 12, 2020 1:15 AM gacha

if you sum with that

Bopit May 12, 2020 1:15 AM gacha

it ignores the text

taxes May 12, 2020 1:15 AM gacha

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

Rusp May 12, 2020 1:15 AM gacha

You know guys

taxes May 12, 2020 1:15 AM gacha

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

Archived external image 2.4 KiB · captured_local

Bopit May 12, 2020 1:15 AM gacha

ok

Bopit May 12, 2020 1:15 AM gacha

so

Bopit May 12, 2020 1:15 AM gacha

in excel

taxes May 12, 2020 1:15 AM gacha

for your error

Bopit May 12, 2020 1:15 AM gacha

you would do

Rusp May 12, 2020 1:16 AM gacha

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

Bopit May 12, 2020 1:16 AM gacha

ctrl+shit+enter

Rusp May 12, 2020 1:16 AM gacha

I drew you an image

Bopit May 12, 2020 1:16 AM gacha

when you use the formula

Bopit May 12, 2020 1:16 AM gacha

which creates an array

Bopit May 12, 2020 1:16 AM gacha

idk if that works for sheets

Rusp May 12, 2020 1:16 AM gacha

This is the official art for this channel now

Rusp May 12, 2020 1:16 AM gacha

image0(222).png 94.2 KiB · captured_local

taxes May 12, 2020 1:16 AM gacha

no its not

taxes May 12, 2020 1:16 AM gacha

go away

Dan K. Meme May 12, 2020 1:17 AM gacha

see rusp

Dan K. Meme May 12, 2020 1:17 AM gacha

you can take my job

Rusp May 12, 2020 1:17 AM gacha

Ikr

Bopit May 12, 2020 1:17 AM gacha

didn't even give the bipen a tail

Rusp May 12, 2020 1:17 AM gacha

Look at the catfish

Rusp May 12, 2020 1:17 AM gacha

It’s so realistic

Dan K. Meme May 12, 2020 1:17 AM gacha

you've been

Dan K. Meme May 12, 2020 1:17 AM gacha

neutered bopit

Bopit May 12, 2020 1:17 AM gacha

fuck

Rusp May 12, 2020 1:17 AM gacha

The jews got to it

Rusp May 12, 2020 1:17 AM gacha

I’m sorry

Bopit May 12, 2020 1:17 AM gacha

that's why I have the helmet

Bopit May 12, 2020 1:17 AM gacha

so they don't take the one on my forehead

Rusp May 12, 2020 1:18 AM gacha

They’re only getting one foreskin

Rusp May 12, 2020 1:18 AM gacha

Better start wearing long sleeve shirts

Bopit May 12, 2020 1:19 AM gacha

hmmm

Rusp May 12, 2020 1:19 AM gacha

When all you’ve got left is 2/3

Rusp May 12, 2020 1:19 AM gacha

You have to protect them with your life

Dan K. Meme May 12, 2020 1:19 AM gacha

they'll knock it down to 3/5ths soon enough

Rusp May 12, 2020 1:20 AM gacha

Wait what

Rusp May 12, 2020 1:20 AM gacha

Oh I guess you have 1 per arm

Rusp May 12, 2020 1:20 AM gacha

Wait that’s still 4

Rusp May 12, 2020 1:20 AM gacha

2 forearms

Rusp May 12, 2020 1:20 AM gacha

1 forehead

Rusp May 12, 2020 1:20 AM gacha

1 foreskin

Bopit May 12, 2020 1:20 AM gacha

max

Bopit May 12, 2020 1:20 AM gacha

the way you wrote it

Bopit May 12, 2020 1:21 AM gacha

I don't think it works

Bopit May 12, 2020 1:21 AM gacha

can you explain what you want it to do?

taxes May 12, 2020 1:21 AM gacha

im saying i want uh

taxes May 12, 2020 1:21 AM gacha

to check a row

taxes May 12, 2020 1:21 AM gacha

wait fuck

taxes May 12, 2020 1:22 AM gacha

okay bopit whats the best way to do this

taxes May 12, 2020 1:22 AM gacha

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

taxes May 12, 2020 1:22 AM gacha

so i have this row

taxes May 12, 2020 1:22 AM gacha

then a summed number

taxes May 12, 2020 1:22 AM gacha

i want to find the number of EXs in this row

taxes May 12, 2020 1:22 AM gacha

times that by 250

taxes May 12, 2020 1:22 AM gacha

then add to the sum at the end

Bopit May 12, 2020 1:23 AM gacha

=sum(if(cell1 = "EX", 250, 0), if(cell2 = "EX", 250, 0), etc

Bopit May 12, 2020 1:23 AM gacha

is that comes to mind

Bopit May 12, 2020 1:23 AM gacha

=if(cell1 = "EX", 250, 0) + if(cell2 = "EX", 250, 0) + etc

Bopit May 12, 2020 1:24 AM gacha

is in my opinion the better way to write it

taxes May 12, 2020 1:24 AM gacha

also your uh

taxes May 12, 2020 1:24 AM gacha

ERROR thing isnt working in the iff

taxes May 12, 2020 1:24 AM gacha

it just leaves stuff as "#name

taxes May 12, 2020 1:24 AM gacha

oh

taxes May 12, 2020 1:24 AM gacha

ik why

Bopit May 12, 2020 1:24 AM gacha

"

Bopit May 12, 2020 1:24 AM gacha

are gay

Archive details

Kappa⁴ Archive

Archive navigation

gacha

Jump to date

Choose a color