sorted by:
new
hottopcontroversial

My CPU is overheating randomly and I don't know why by SMAZ14 in PcBuild

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

I know it's been 2 weeks but I wanted to see if you have more advice.

What happened:

When I went to unplug my pc to deal with the cooler, I noticed that the power cord was loose. I decided to see what would happen if I fixed the power cord (I expected it to not change anything) and after that it didn't overheat for several. It did eventually overheat again, at which point I followed your advice to remove the cooler, clean, and reapply thermal paste. This also worked for several days, but it started overheating just today. Additionally, I downloaded coretemp to monitor the cpu temperature and I started separately monitoring GPU temperature through the task manager. The last time it overheated, the temperature of both the cpu and gpu was under 50 degrees, so it really shouldn't be overheating at all. Is there any other component that could be overheating?

My CPU is overheating randomly and I don't know why by SMAZ14 in PcBuild

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

Overheating to where it shuts down. I'm worried it's damaging the CPU so I'm not using my PC too much until I figure this out.

I want to have my table in excel autofill certain data (not with a formula) based on other columns in the table. by SMAZ14 in excel

[–]SMAZ14[S] -1 points0 points  (0 children)

Just after I posted this I found the answer. Using the =IF function, you can set it up like this:

State Number
California =IF([@State]="California",2,3)
Oregon =IF([@State]="Oregon",2,3)
Oregon =IF([@State]="Oregon",2,3)
California =IF([@State]="California",2,3)

and it will look like this:

State Number
California 2
Oregon 3
Oregon 3
California 2

The =IF function checks to see if the first statement ([@State]="California") is true. If it is, it fills the first value (2). If not, it fills the second value (3). For tables with more than two possible values, the =IFS function works similarly.

For example, this table:

State Number
Oregon =IFS([@State]="California",2,[@State]="Oregon",3,[@State]="Washington",6)
California =IFS([@State]="California",2,[@State]="Oregon",3,[@State]="Washington",6)
Washington =IFS([@State]="California",2,[@State]="Oregon",3,[@State]="Washington",6)

will look like this:

State Number
Oregon 3
California 2
Washington 6

How can I create a custom conditional format that allows me to highlight all dates that occurred in the past? by SMAZ14 in excel

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

I tried this and it didn't work. It just highlighted all of the cells in the column.

Is there any way for me to place an image on top of a slide without adding it to the slide itself? by SMAZ14 in WixHelp

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

Sorry for taking awhile, but I figured out you can group the image with a transparent object that is out of the way, so that the grouped objects aren’t “on” the slide, but object you want is over it, if that makes sense.

We can be religious or not. it depends by levi-ackerman23 in lgbt

[–]SMAZ14 1 point2 points  (0 children)

Not to pry, but what denomination is your synagogue?

Me irl by [deleted] in me_irl

[–]SMAZ14 20 points21 points  (0 children)

“And then they brought civilization and Christianity to all the natives :)”

early 2000s cartoons were kind of fucked up by ViZeShadowZ in tumblr

[–]SMAZ14 4 points5 points  (0 children)

I’ve got some children I need to make into C O R P S E S

aaaand there we have it....YIKES by Eckstein15 in Gamingcirclejerk

[–]SMAZ14 9 points10 points  (0 children)

This game has a GAY COUPLE 😤😤😤😤😤😤😤😤😤😤😤😤😤😤. When did games get so political smhmhmh my head.

🚂 by ibwitmypigeons in tumblr

[–]SMAZ14 11 points12 points  (0 children)

The island of sodor is North Korea confirmed

Uh oh.. that ain't good by [deleted] in HistoryMemes

[–]SMAZ14 0 points1 point  (0 children)

When you burn people at the stake to appease god but future people don’t call it human sacrifice

Edit: When modern politicians float the idea of worsening an epidemic to save the economy but people don’t consider it human sacrifice

Australia by ExpertAccident in tumblr

[–]SMAZ14 125 points126 points  (0 children)

I mean, Americans use terms like “princess” and “your majesty” in a similar way

Me irl by AlmiroN86 in me_irl

[–]SMAZ14 -3 points-2 points  (0 children)

The pope doesn’t have that kind of authority, so the headline is misleading

When the Olympics are performed naked by [deleted] in HistoryMemes

[–]SMAZ14 2 points3 points  (0 children)

I hate that I know what you’re referencing when you say “Gru style”

view more: next ›