Question Numbers question - can a yes / no answer be used to select a number

[existentialist]

Which is all well and good

BUT

I'm not doing this in fucking Excel, am I, I'm trying to do this in bloody Numbers

Numbers definitely has the IF() function, but I can't find anything in the documentation about string comparisons, though I am sure it works pretty much the same as Excel, etc. There's also a REGEX comparison which might solve the Y/y/yes/Yes problem, but I think we're not quite ready for that yet.

 

[Puddy_Tat]

spend 5 minutes on that and two hours on choosing the colours for conditional formatting to make sure it looks pretty

Plus hiding derisive messages about the colleagues who asked me to make them spread sheets because they were too lazy to learn to do it themselves …

 

[High Voltage]

Numbers definitely has the IF() function, but I can't find anything in the documentation about string comparisons, though I am sure it works pretty much the same as Excel, etc. There's also a REGEX comparison which might solve the Y/y/yes/Yes problem, but I think we're not quite ready for that yet.

WHAT1!!!11!!!

I've only just figured out the easy way to enter a formula into a cell FFS without having to go the long winded way of drop down menu

I am happy in my ignorance

 

[A380]

Which is all well and good

BUT

I'm not doing this in fucking Excel, am I, I'm trying to do this in bloody Numbers

Don’t Apple just copy every function from MS and make the corners look squarer?

 

[High Voltage]

I don't know

I only use Adobe products and, begrudgingly some Esko products in my day to day

All this "programming" bollocks is for you nerdy lot

Leave me with my typefaces and pretty colours

 

[existentialist]

I don't know

I only use Adobe products and, begrudgingly some Esko products in my day to day

All this "programming" bollocks is for you nerdy lot

Leave me with my typefaces and pretty colours

Spreadsheet formulas really aren't programming.

 

[High Voltage]

Spreadsheet formulas really aren't programming.

They are in my world

 

[High Voltage]

Anyhow I have an answer - so thank you one and all (well, except one of you, and we all know exactly who "that one" is, don't we)

 

[A380]

Did I mention I’m using Google Sheets now….

 

[farmerbarleymow]

Anyhow I have an answer - so thank you one and all (well, except one of you, and we all know exactly who "that one" is, don't we)

You're proper grumpy today.

 

[existentialist]

You're proper grumpy today.

He's having to write spreadsheets. It's an inevitable consequence.

 

[Numbers]

Which is all well and good

BUT

I'm not doing this in fucking Excel, am I, I'm trying to do this in bloody Numbers

I was making Love to Mrs Numbers, now I'm fucking Excel.

I'll take one for the team but give us a fuckin heads up at least, FFS.

 

[A380]

He's having to write spreadsheets. It's an inevitable consequence.

No, nothing like a good spread sheet to make the hours whiz by.

 

[existentialist]

No, nothing like a good spread sheet to make the hours whiz by.

The trouble is, there's nothing like a good spreadsheet.

 

[two sheds]

No, nothing like a good spread sheet to make the hours whiz by.

while potentially saving many hours of boring adding up in the future. I did one for my accounts a good 20 years ago and it takes quarter of an hour each month and an hour at the end of the year and everything's calculated for tax. Not guaranteeing that it's all correct of course but good enough for me

 

[A380]

The trouble is, there's nothing like a good spreadsheet.

You’ve just not written a good one yet…

 

[Pickman's model]

Traditionally, input validation/sanity checking has no place in Excel!

There ain't no sanity clause

 

[existentialist]

You’ve just not written a good one yet…

Too damn right. I normally reach for python when I'm looking at my third lookup table.

I saw so many doomed spreadsheets in my IT days - ludicrous confections that were incapable of any kind of testing or audit, inevitably ran up against some sort of hard limit, and had zero documentation - to want to do anything much beyond trivial using a spreadsheet.

 

[weltweit]

One of the great things about IF statements is that you can daisy chain them, so you can say
IF(X1-Y then A or if not IF(x1=B then B or if not " "))

 

[High Voltage]

Brain Explosion GIF - Brain Explosion - Discover & Share GIFs

 

[farmerbarleymow]

One of the great things about IF statements is that you can daisy chain them, so you can say
IF(X1-Y then A or if not IF(x1=B then B or if not " "))

I like IF formulas - it's quite satisfying crafting them.

 

[Shippou-Sensei]

It always feels nice to make a well crafted IF statement.

Also true of a fancy SQL query.

 

[Shippou-Sensei]

Did you manage to do it in the end?

 

[Puddy_Tat]

There ain't no sanity clause

 

[High Voltage]

Did you manage to do it in the end?

Yes I did

As with most things "computery" I'd already done it as someone suggested, but for some unknown reason didn't work then it did

How computers ever caught on its a mystery to me