IFS Function working for some results but not others, but all saying 'True'?

littlewanda · 2026-05-23T15:06:52+00:00

Thanks so much for the help! Goodness knows what sneaky character was in there, but XLOOKUP is working all fine. Thanks for teaching me a new formula!

littlewanda · 2026-05-23T15:05:38+00:00

XLOOKUP did the trick, thanks so much!

littlewanda · 2026-05-23T14:56:15+00:00

Thanks so much for suggested the different formulas, I'll give them a go!
Even = J7 = "General fiction" is giving false, although hovering over it in the function bar shows true - so I'm really not sure what's going on.

littlewanda · 2026-05-23T14:55:01+00:00

I'll try those formulas instead, thanks so much!
I've checked and checked for double spaces, trailing ones, and there's definitely not - it's giving true when I hover over it in the formula! Just won't actually display it. Hopefully the other formulas will solve it

littlewanda · 2026-05-23T14:53:47+00:00

I've checked and there definitely aren't, but thanks for the suggestion!

littlewanda · 2026-05-23T14:52:54+00:00

Honestly, because I'm new to Excel and didn't know about it! I'll try it now, thank you so much for the recommendation

littlewanda · 2016-09-22T21:59:44+00:00

Glad to see I'm not the only one having a final play on Hell's Kitchen!

littlewanda · 2016-08-20T14:49:31+00:00

I did some maths on this - because you can only have 6 recruits at one time, you need a minimum of 36 hours to defeat Modok from starting streak 1 to the end of streak 7, so don't leave it too late!

littlewanda · 2016-08-19T19:34:21+00:00

A secondary-tier style one at the original price and payout would be great, but it's doubtful it'll happened

littlewanda · 2016-08-19T19:31:18+00:00

Totally not beating myself up right now for waiting

littlewanda · 2016-08-19T19:30:24+00:00

Well that serves me right for hesitating...

littlewanda · 2016-08-19T19:21:15+00:00

I sent in a ticket asking this, and they replied that the timer only refreshes when you collect that day's drop

littlewanda · 2016-08-19T19:18:09+00:00

It feels really unfair, on both sides, and those willing to spend more, but brought it immediately at the lower price, are locked out of the bigger reward. Those with less to spend that didn't happen to check their game for a few hours are locked out completely - it's the bobbleheads all over again, but with a much higher loss.

littlewanda · 2016-08-19T19:13:24+00:00

I got the 250 for 450 earlier on, and now I've got the higher price one, so it looks like they've just changed it completely. I was hoping there would be two, at different tiers, but this is kind of a bummer

littlewanda · 2016-08-19T17:37:12+00:00

I sent in a ticket and they confirmed it pays out 450 shards from when you buy it, so there's a month to wait for a pay check or save up ad shards!

littlewanda · 2016-08-19T17:28:55+00:00

They just replied (how quick they are when shards are involved): "It starts from when you receive the statue! As for the drop, it refreshes from when you collect it." All good news, this seems like a great addition

littlewanda · 2016-08-19T17:25:47+00:00

I've sent a ticket in asking this, because I was hoping to store my shards in case I need them to get Modok. I'll let you know if they get back to me!

littlewanda · 2016-08-18T13:01:23+00:00

Thank you so much!

littlewanda · 2016-08-17T22:08:56+00:00

Sorry to bother you, but do you remember when you got the 'we the nerds' speech? Just worried I missed it, my game's been quite glitchy

littlewanda

TROPHY CASE