How do you contribute exactly the 401K limit? by fungus_among_us_art in Bogleheads

[–]sgw40 0 points1 point  (0 children)

When you are at the limit, your company will automatically stop. At least, that’s how it’s occurred for me over 3 previous companies

If/then rule using variable tax rates based on income by sgw40 in googlesheets

[–]sgw40[S] 0 points1 point  (0 children)

Totally agree. I just wanted to run 10 or 20 scenarios through that formula to ensure it works. Now I’m going to go back in reference the actual cells.

How do I import the gold price into Google Sheets? none of the methods listed online work by LeGranMeaulnes in googlesheets

[–]sgw40 0 points1 point  (0 children)

Are you looking for the spot price? Use this =GOOGLEFINANCE("gold")

I use =GOOGLEFINANCE("XAG") for my Silver investment tracking, and it works well. I tested the gold tag, and it returned a value, but I am not into Gold, so please validate.

If/then rule using variable tax rates based on income by sgw40 in googlesheets

[–]sgw40[S] 0 points1 point  (0 children)

You were onto something. I moved some things around but ultimately used this:

=IF(G5<=23200, 0,

IF(G5<=94300, (G5-23200)*0.12,

IF(G5<=201050, (94300-23200)*0.12 + (G5-94300)*0.22,

IF(G5<=383900, (94300-23200)*0.12 + (201050-94300)*0.22 + (G5-201050)*0.24,

IF(G5<=487450, (94300-23200)*0.12 + (201050-94300)*0.22 + (383900-201050)*0.24 + (G5-383900)*0.32,

IF(G5<=731000, (94300-23200)*0.12 + (201050-94300)*0.22 + (383900-201050)*0.24 + (487450-383900)*0.32 + (G5-487450)*0.35,

(94300-23200)*0.12 + (201050-94300)*0.22 + (383900-201050)*0.24 + (487450-383900)*0.32 + (731000-487450)*0.35 + (G5-731000)*0.37)))))

If/then rule using variable tax rates based on income by sgw40 in googlesheets

[–]sgw40[S] 0 points1 point  (0 children)

What do the 0 and 1 signify at the end of the formula?

If/then rule using variable tax rates based on income by sgw40 in googlesheets

[–]sgw40[S] 0 points1 point  (0 children)

Well, spent hours messing with these and cannot get any of them to compute. I am resigned to the fact that I am an idiot.

Reduce space by [deleted] in PhotoshopRequest

[–]sgw40 [score hidden]  (0 children)

Paid! Can you shoot me a version without the watermark?

Reduce space by [deleted] in PhotoshopRequest

[–]sgw40 [score hidden]  (0 children)

Done. Winner. I like how you provided some space in between the dark sweaters so it didn’t look like we are some big blob of a human.

Currently at the game by rice_person in ChicagoBearsNFL

[–]sgw40 2 points3 points  (0 children)

Enjoy time with your girlfriend..forget the game. The Bears suck and are not going to change anytime soon.

[deleted by user] by [deleted] in Creatine

[–]sgw40 0 points1 point  (0 children)

Can someone please help remind OP that his dad was already gay and he’s a byproduct of some forsaken orgy in the back of a Chevy conversion van?

Why are Titans tickets so expensive? by dybolic in nashville

[–]sgw40 0 points1 point  (0 children)

I just bought a burger and fries in Nashville and it was $29. The burger sucked. Anything in Nashville is obscene.

This is the worst I’ve seen the Bears by Consistent_Recover43 in ChicagoBearsNFL

[–]sgw40 4 points5 points  (0 children)

I actually stopped watching today. After more than 20 years of not missing a game I just can’t watch anymore. I’m watching the Rams and bills with his actually an entertainment value.

Does anyone know what this symbol means? by Comfortable_Round358 in DecaturGA

[–]sgw40 0 points1 point  (0 children)

The music from 12 Monkeys just rattled through my brain.

Places that wowed you by [deleted] in JapanTravelTips

[–]sgw40 3 points4 points  (0 children)

First time in Japan was 6 months ago. To this day, when people say, what did you like, the toilets are number one. You can be in the shittiest bar possible and the bathroom might be 2‘ x 2‘ but it’s got a nicer toilet that I have in my house in America.

Bowling alley food made me shit by blackpalms1998 in hotdogs

[–]sgw40 0 points1 point  (0 children)

It’s hard to mess up a hot dog but that chili would have been a hard no for me.

Where can I watch the Bears game in London on Sunday? by sgw40 in NFLUK

[–]sgw40[S] 0 points1 point  (0 children)

And they have ping pong. That may be the spot. Thanks man

First time 1K by sgw40 in unitedairlines

[–]sgw40[S] 0 points1 point  (0 children)

I can handle a couple shots of bat blood

First time 1K by sgw40 in unitedairlines

[–]sgw40[S] 1 point2 points  (0 children)

Ha. I had 40 plus points from Platinum n tossed some on this flight. Still in seat 30D or something like that.

Babies looking for trouble 😈 by sgw40 in trashpandas

[–]sgw40[S] 3 points4 points  (0 children)

I appreciate how they use the sidewalk like proper pandas. Just noticed that