bald_pig

Ok, this should be what you need in the BD column: =(SUM((SUM(F2,J2,AK2,AM2,AP2)*3),G2:I2,K2:AJ2,AL2,AN2:AO2,AQ2:BC2)/60) I've added extra brackets to section it out (SUM(F2,J2,AK2,AM2,AP2)*3) Tallies the three point answers and multiplies by three to give the correct points, this is within: SUM(([i]3 point answers[/i]),G2:I2,K2:AJ2,AL2,AN2:AO2,AQ2:BC2) To give the overall score, this is then divided by 60 (max number of points) to give your percentage.

I guess you want the result in the sheet 2 BD column?

Send us the spreadsheet example so I can see how you have laid out the questions and whatnot

Basically anything that gets repeated goes in it's own cell, and the main formula references that instead!

I know, but he wanted it all in one cell, otherwise I'd break most of it out into separate cells.

I spied the Excel in the footage! I wasn't too excited for this, but the visuals look stunning!

I feel like this needs explanation, the countif returns the number of cells that are below 80%, and it's a series of if statements, so if 1 cell is below 80%, 2 below 80% etc. Within that, it's more if statements! if the average of the cells is above the threshold, return the threshold, else return the average. I'm sure there's a neater way of doing it, but it's the only way I could think of doing it where I could cram it all in to one cell!

If it's stupid, but it works, it ain't stupid, right? =IF(COUNTIF(B2:B6,"<80%")=1,IF(AVERAGE(B2:B6)>=80%,79.9%,AVERAGE(B2:B6)),IF(COUNTIF(B2:B6,"<80%")=2,IF(AVERAGE(B2:B6)>70%,70%,AVERAGE(B2:B6)),IF(COUNTIF(B2:B6,"<80%")=3,IF(AVERAGE(B2:B6)>60%,60%,AVERAGE(B2:B6)),IF(COUNTIF(B2:B6,"<80%")=4,IF(AVERAGE(B2:B6)>50%,50%,AVERAGE(B2:B6)),IF(COUNTIF(B2:B6,"<80%")=5,IF(AVERAGE(B2:B6)>40%,40%,AVERAGE(B2:B6)))))))

And even if it's not certified you can turn it on anyway but YMMV™

They have been able to for a while now:

I picked up this monitor for £190 last week via their ebay store, missus won't let me use it until my birthday though

Switches don't actually need to be on the network, they just build a database of which port they can contact an ip address through, and sling any packets it receives through the appropriate port. (Heavily simplified)

Everything and Metro:2033 Redux are free on the Epic games stores at the moment

They are probably still on a default address and not picked up DHCP. Check the default ip address for each switch, set your laptop to be on the same range, then connect directly to the switch and connect to the default ip in your browser.

Everything will just go back to sea travel, the prices of everything will go up to account for the delay in shipping, and the waters will be polluted by tankers even more. Sounds like a great plan...

Also found this: https://superuser.com/questions/1224233/invisible-png-image-layer-that-is-only-visible-as-a-background

Have you tried opening the file with 7zip? It's possible to hide archives in images.

This has been explained to you more than once now, are you being dense or awkward?

I don't have the room to do it, but once I do... BTW, if it's any good I'll be expecting some to try at BETT!

That's great and all, except no airline would ever be formed again, since new businesses of that scale would need financing to start up...

For a company who's product revolves around Google services, their knowledge of Google services has me a little worried right now...

"This stream is not available to your domain" Makes you sign in, compains with personal and g suite account... @ZeroHour @Dos_Box

What do you think the ATOL scheme is?

It could be that light is swamping out the ir sensor on the screen, it's one of those things where you need to be there and see what's going on in the room at the time.

Have you watched him try? Sounds like it's going to be user error if you replaced everything, either pointing the remote so the screen doesn't get the signal, or pressing the wrong button, mashing it twice or something along those lines.