Jump to content

Recommended Posts

I'm conducting a little family game (in various countries)based on guessing the scores of each team in the RWC this w/end.


Points are accumulated from the distance your guess is to the actual score. I'm trying to put this on a spreadsheet for simplicity. However if I use a simple calculation of deducting the actual less the guessed score I'm likely to get a plus or minus figure eg Wales score 10 points. One guess is 15, their score is 5. Another guess is 7 so their score is 3. However using the same calculation for the first one the result would be -3.


Is there a way to make all answers positive regardless of the figure being above or below a certain number?


Don't go to a lot of trouble if there isn't a simple answer. Thanks.

Link to comment
https://www.eastdulwichforum.co.uk/topic/19940-excel-expert-please/
Share on other sites

  • 2 years later...

Another small problem.I'd be grateful for help.


I cut and pasted two columns of figures from the company software to a spreadsheet. In a third column I want to compare the first two columns for differences or not as the case may be.


I can do this if I'm just using figures which weren't imported as in A1-B1=C1


However something is stopping that happening which I'm sure is due to the importation in that there is something in the cells other than the figures, which doesn't allow the normal formula to work.


Can someone explain what I need to do to purge the cells of whatever it is and leave me just with the imported figures. I could spend hours figuring it out but I need to do something in a hurry.


Thanks.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Latest Discussions

    • You keep insisting that you're "just stating facts", but so far, most of what you've shared isn't fact - it's just your personal opinion, framed with hostility.  Foxes aren't classified as "vermin" in the UK. They're wild animals protected under the Animal Welfare Act & the Wildlife & Countryside Act . & Yes, they do play a vital role in controlling rodent population. The more you double down on insults & misinformation, the more you discredit your own argument. It's possible to be fed up & still informed. Take the information provided to you & do something about it. BTW culling doesn't even work.
    • It’s hardly likely you know that for a fact Sue
    • I know an instance where the foxes quickly learned how to avoid such devices. 
    • I did read the comments above It's not moaning, it's stating facts. Tell you what,  you can come and clear up the near daily fox crap and see how you like dealing with it, no didn't think that would appeal to you.  Do they control rodents?  Foxes are vermin.  It's an emotive topic for some, I realise that, however the facts are foxes are a pest.
Home
Events
Sign In

Sign In



Or sign in with one of these services

Search
×
    Search In
×
×
  • Create New...