Ask General Programming Questions Not Worth Their Own Thread

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Ask General Programming Questions Not Worth Their Own Thread

YardKGnome: Jan 18, 2003; Grimey Drawer

Femtosecond posted:

I have a bit of code that I'm working on, and it has a use of '&' that I've never seen before.

I've seen rand() % 3 used a million times before, but never the &. It's still giving me random numbers but it seems like it's doing something a bit different. What does this do?

3 is 0011 in binary. & is the bit-wise and operator. Basically, its giving you a random number between 0 and 3 (inclusive). It is equivalent to "% 4"

# ¿ Mar 3, 2008 06:14

Adbot: ADBOT LOVES YOU

# ¿ Apr 29, 2024 05:01

YardKGnome: Jan 18, 2003; Grimey Drawer

very posted:

That seems like a bad idea. Somebody is going to want to add another case, change the 3 to a 4, and now you have a bug.

Yup. Seems like a pretty bad idea in general.

# ¿ Mar 4, 2008 04:23

YardKGnome: Jan 18, 2003; Grimey Drawer

Hughmoris posted:

I'm trying to create a budget and expense tracker in google spreadsheet and I'm having a bit of trouble writing a function.

I want to write a function that will run through column D, and if it finds a Food transaction, add the appropriate amount to a running total in cell E2. The same goes for Gas and Misc. I tried searching their help topics but I can't figure it out. Thanks for the help.

Try

code:

=SUMIF(D6:D,E1,B6:B)

That is a sum of the values in row B (after B6) if the values in row D (after D6) match the value of the cell E1 (Food).

# ¿ Sep 2, 2012 21:46

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Ask General Programming Questions Not Worth Their Own Thread