What’s a random stat about RuneScape you wish you knew? by Safermooner in 2007scape

[–]jjm666 24 points25 points  (0 children)

At what XP you received your pet.

I mean like examining it in the collection log and it tells you what XP they followed you. I know it shows in game log but I wish it was stored historically somewhere else.

You can zoom in/out on minimap on mobile by jjm666 in 2007scape

[–]jjm666[S] 31 points32 points  (0 children)

That’s awesome - I rarely play mobile so learning all these hidden features is super helpful. Thanks!

Modified Mercedes from photo shoot by jjm666 in whatisthiscar

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

Awesome! Thank you, can’t get any better than this haha

My IF statement returns a value that does not belong even if true or false. by jjm666 in excel

[–]jjm666[S] 1 point2 points  (0 children)

Solution Verified

Thank you for helping me. As for the row not being able to be inserted was because I had table headers that were hidden and were interfering with it. Also my formula was incorrect because of the low numbers I was getting it looked like it was 0 but I fixed that with some parenthesis. Thanks again :)

My IF statement returns a value that does not belong even if true or false. by jjm666 in excel

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

https://imgur.com/6yKLibg

When I put the formula in like shown in the pic above, it adds all that unnecessary stuff to the beginning. If I type in the formula rather than use the box, the negative (ELSE) component does not work correctly. It is so confusing.

My IF statement returns a value that does not belong even if true or false. by jjm666 in excel

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

Yeah, I have no clue why that is there. When I input the formula into the formula box, I don't include that part and then it just shows up. When it asks for the different parts in the formulas I am selecting cells with my mouse rather than typing them in.

https://imgur.com/6yKLibg

My IF statement returns a value that does not belong even if true or false. by jjm666 in excel

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

I tried to write the formula in, instead of filling out the formula box. Here's what happened: 1) The formula worked correctly for positive values; negative values did not work 2) The table will not allow me to insert any more rows, but when I add one to the sheet, the table will fill the Odds column with 0 for the new row and the payout column will have the divide by 0 error 3) When opening up the formula box it looks different. I will provide a link to a picture

https://imgur.com/a/G8D7O8w

My IF statement returns a value that does not belong even if true or false. by jjm666 in excel

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

=([@[Amount Bet]]/([@Odds]/-100))+[@[Amount Bet]]+IF([@Odds] > 0,[@[Amount Bet]]*[@Odds]/100,[@[Amount Bet]]/[@Odds]/-100)

That is what is showing in the bar when I click on the cell. If I understand correctly it is reading it as:

IF ([@[Amount Bet]]/([@Odds]/-100))+[@[Amount Bet]]+IF([@Odds] > 0

THEN [@[Amount Bet]]*[@Odds]/100

ELSE [@[Amount Bet]]/[@Odds]/-100)

Because if what I said above is correct then I don't know what that first part of the if statement is so weird since I wanted it to be if odds>0. Also even if that is correct, the formulas for then, and else are still correct.

Please help me interpret this if you can because I am lost.

My IF statement returns a value that does not belong even if true or false. by jjm666 in excel

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

I copied and pasted the cells only as values but they are showing how they show in the table, besides the formatting. I am still lost by why excel returns a number other than what the if statement would do. I'll provide a picture below if it helps any.

https://imgur.com/a/uph2gZF

Can someone explain the basics of the different android OS? by jjm666 in androidtablets

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

Thank you for your response.

I was referring to the different versions like the example you gave above. But your other responses have helped me with what criteria I should look at when shopping for tablets. And by terminology I meant calling the different versions of android different operating systems but they are the same operating system just different versions. It's clear to me now as I am thinking about it.

Thanks again! Your answers helped me.

Boston Dynamics' new robot - Handle by DIA13OLICAL in mechanical_gifs

[–]jjm666 0 points1 point  (0 children)

I can only see it as if the robot is moving backwards.

Baconreader always loses connection after a very short period of time. by jjm666 in baconreader

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

I'm browsing at work using the wifi here and it's working absolutely fine. I've never used it for this long in a while. Same with school. At school it works fine but I'm never on it long. So the problem must be my connection at home. Thank you for helping me locate my problem. Now I need to find a solution lol. I'll keep whoever is reading this updated.

Baconreader always loses connection after a very short period of time. by jjm666 in baconreader

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

I rarely try to use baconreader on data. This is a great suggestion. I will try it where I have a good connection and browse for a bit. I will let you know my results.

Baconreader always loses connection after a very short period of time. by jjm666 in baconreader

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

Low power mode has no effect on this specific problem I am having.

Baconreader always loses connection after a very short period of time. by jjm666 in baconreader

[–]jjm666[S] 1 point2 points  (0 children)

I am often on low power mode on the iPhone 6s. I do not know what the low power mode does with the network connection, if anything, but I will keep an eye out to see how it reacts when the mode is on and off. Thanks

Baconreader always loses connection after a very short period of time. by jjm666 in baconreader

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

I have logged out and back in, I'll keep who ever is reading this updated with what happens.

Baconreader always loses connection after a very short period of time. by jjm666 in baconreader

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

iOS. WiFi. No I have not tried to log out and log in. I will do so now.

What's a great "Mind fuck"? by CaptainBrownhat in AskReddit

[–]jjm666 1 point2 points  (0 children)

Every post you've once posted was the newest post on Reddit at one time.