thats the true question
lgbtq-plus
"Nine Lives ROMA" - Romulus · Quirinus
Jump to date
Tuesday, May 12, 2020
unsure
or I could do it manually
for 300 servants
i think the + would fuck it up
but i dont know
@Spooky Phijkchu
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
how many )s i need
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
