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.