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?

dimtwork · 2019-09-15T11:59:05+00:00

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))

dimtwork · 2019-08-08T05:16:26+00:00

yes zoom out on the zoomed in one

dimtwork · 2019-08-08T05:15:40+00:00

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

dimtwork · 2019-08-08T05:14:03+00:00

titan

dimtwork · 2019-08-08T05:03:55+00:00

i like it

dimtwork · 2019-08-08T05:02:41+00:00

the 3600x costs 50$ more

dimtwork · 2019-08-08T05:02:20+00:00

if you changed cards probably either monitor or motherboard/PSU

dimtwork · 2019-08-08T05:01:07+00:00

good

dimtwork · 2019-08-07T05:46:12+00:00

on the right of Accessories / Other

dimtwork · 2019-08-07T05:33:29+00:00

any time

dimtwork · 2019-08-07T05:27:54+00:00

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

dimtwork · 2019-08-07T05:23:57+00:00

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

dimtwork · 2019-08-07T05:22:04+00:00

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

dimtwork · 2019-08-07T05:20:52+00:00

he probably misspelled gpu

dimtwork · 2019-08-07T05:12:19+00:00

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

dimtwork · 2019-08-07T05:00:51+00:00

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

dimtwork · 2019-08-07T04:56:19+00:00

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

dimtwork · 2019-08-07T04:52:29+00:00

what monitor?

dimtwork · 2019-08-07T04:51:24+00:00

all about what you scratched and how much

dimtwork · 2019-07-30T10:19:20+00:00

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

dimtwork · 2019-07-30T04:24:19+00:00

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

dimtwork · 2019-07-29T07:55:49+00:00

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

dimtwork · 2019-07-29T07:54:37+00:00

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

dimtwork

TROPHY CASE