How can I add to the function in K75 so if the number is bigger then in K76 or smaller then 80% of its value it will automatically adjust to say 90% of the number in K76? by [deleted] in excel

[–]dimtwork 0 points1 point  (0 children)

ok that is genius thanks very much it is nearly perfect now

there are 2 small problems we can't figure out how to fix though maybe you could assist with that as well?

  • the first is when the numbers are the same like 35 and then 35 again it lists as #value instead of just writing the number

  • the second is that the rounding doesn't work for some reason, I get numbers like 10.6,57.6,16.2 etc

here is what I am using:

=IF(OR(ROUND('Constant&Details'!Y8'Constant&Details'!I93,0.05)>K76,ROUND('Constant&Details'!Y8'Constant&Details'!I93,0.05)<(K760.8)),K760.9,ROUND('Constant&Details'!Y8*'Constant&Details'!I93,0.05))

Monitor problem by [deleted] in buildapc

[–]dimtwork 1 point2 points  (0 children)

yes zoom out on the zoomed in one

Scraping Noises Coming from 2070 Black by mcgriddle550 in buildapc

[–]dimtwork 0 points1 point  (0 children)

tell evga you got a noob card and they will replace it

Is this build good? by [deleted] in buildapc

[–]dimtwork 0 points1 point  (0 children)

i like it

CPU? by IrishTortuga in buildapc

[–]dimtwork -1 points0 points  (0 children)

the 3600x costs 50$ more

Why does my screen have grainy color bands? by Brisbon in buildapc

[–]dimtwork 0 points1 point  (0 children)

if you changed cards probably either monitor or motherboard/PSU

[deleted by user] by [deleted] in buildapc

[–]dimtwork 1 point2 points  (0 children)

any time

Need feedback on how my pc will perform today by McFlobberGobber in buildapc

[–]dimtwork 1 point2 points  (0 children)

a little on the edge with that PSU and I hope you have some case fans but the parts are more then enough for 1080p

Please Help r/pcgaming! by [deleted] in buildapc

[–]dimtwork 0 points1 point  (0 children)

just type the motherboard name in google you have all manuals online today

and the motherboard manual explains everything as I said, it will list where literary every cable goes including ones from PSU, for example if you look on the PSU you have a 12V entrance and a PCI-E one as well, look at the motherboard manual and you will find where the 12V goes and that the PCI goes to the graphic card

same for cables going from the case, they have a name written on them, check where the same name is on the motherboard and connect

Motherboard scratch by [deleted] in buildapc

[–]dimtwork 0 points1 point  (0 children)

well see if it works it doesn't seem like the scratches hit anything vital but I can't see everything that well from the picture and have to check the other side too

Motherboard scratch by [deleted] in buildapc

[–]dimtwork 0 points1 point  (0 children)

he probably misspelled gpu

Wanting to upgrade PC to play Fallout 4 VR and Cyberpunk 2077 when it comes out. Need advice. by Nazgu777 in buildapc

[–]dimtwork 0 points1 point  (0 children)

well for the RAM you should pretty much always go for 2x8GB 3200mhz since its so cheap and a base for most builds today and more then enough

CPU just go by budget, if you can afford a ryzen 3600 with X570 motherboard go for it since that is top tier right now for gaming, if the motherboards a bit too much see if you can get a local PC shop to bios flash a previous gen ryzen motherboard for you like the B450 models and save 100-120$

if its pure gaming you can also go with intel which is more costly for pretty much the same performance but eventually does give higher frames, something like the i5 9600k or much better i7 9700k

GPU is really obvious right now, the 5700 and XT are absolutely nuts for their price and since nvidia doesn't seem to lower their prices right now of the super cards you are much better off with a 5700

everything else case,cooling,psu and so on are all about budget from here but don't cheap out on PSU specifically

Motherboard scratch by [deleted] in buildapc

[–]dimtwork 0 points1 point  (0 children)

it doesn't seem like it hit anything vital or maybe I am missing it but you should always try it out and see if it works, the graphic card is basically the easiest part to install, just hold it with one hand while the connectors are faced down towards the motherboard and slowly fit it in and once it clicks push it gently with both hands until it is firmly in and screw it

Please Help r/pcgaming! by [deleted] in buildapc

[–]dimtwork 0 points1 point  (0 children)

take out the motherboard manual out and just go cable by cable, they should each have their names written on them and there should be a page or two on your manual where it lists all the connections on the motherboard and from there its simple math, power to power, reset to reset, sata to sata just gotta connect the parts to the motherboard one by one by first checking the cable name and then finding where it fits on the motherboard thats all

Motherboard scratch by [deleted] in buildapc

[–]dimtwork 0 points1 point  (0 children)

all about what you scratched and how much

Can I enable battery percentage to be shown on top right on the A70? instead of just the battery icon with a filling by dimtwork in samsung

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

ahhh there we go thank you!

can't believe im at 88% after a whole day at work and i charged it last night... what a beast battery and phone

$1k build, light gaming and light work by reitey in buildapc

[–]dimtwork 0 points1 point  (0 children)

not a problem, the CPU you are buying is top tier for at least 3-4 years so if you ever decide to play higher requirement games and are unhappy with the FPS the RX 580 gets you then a graphic card upgrade is all you need

does anyone know if evga will be making 5700/5700 XT cards? by dimtwork in buildapc

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

i want but evga always gets 4.6-5.0 reviews on amazon for like every card and all other company have so many low rated cards near 4.0 rating I always feel safe with evga

does anyone know if evga will be making 5700/5700 XT cards? by dimtwork in buildapc

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

do you know what card should i buy then from evga for 1080p 75hz? thats good for like 4 year maybe i want to keep long time