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

[High Voltage]

This is either going to be super easy (and you'll all laugh) or impossible (and you'll all laugh)

Is it possible, in numbers, to put either a Y or a N in a cell and depending what is put in that cell to populate a different cell with one of two numbers to be used in a calculation

I'm trying to refine a very basic form that inputs width and height dimensions in mms, converts them to inches, rounds that answer up to one decimal place, then calculates the total square inch area - I've got this working

What I want to do is have another cell with a yes / no "thing" and depending on the Y or N this would then add either 65mm or 25mm to the width and height dimensions

Do'able?

 

[Numbers]

You have my blessing, go ahead.

 

[platinumsage]

Took me a while to realise this wasn't about numbers but about Numbers, a thing I know nothing about.

 

[farmerbarleymow]

Is it possible, in numbers, to put either a Y or a N in a cell and depending what is put in that cell to populate a different cell with one of two numbers to be used in a calculation

I'm trying to refine a very basic form that inputs width and height dimensions in mms, converts them to inches, rounds that answer up to one decimal place, then calculates the total square inch area - I've got this working

What I want to do is have another cell with a yes / no "thing" and depending on the Y or N this would then add either 65mm or 25mm to the width and height dimensions

Do'able?

Yes.

 

[High Voltage]

Yes.

How so?

 

[farmerbarleymow]

How so?

Easily.

Can't be bothered to explain - going back to bed shortly. But you might be able to get it to work with conditional logic formulas

 

[High Voltage]

Hope seas gulls keep you awake

 

[Aladdin]

Yes
Its called Minesweeper

 

[High Voltage]

Easily.

Can't be bothered to explain - going back to bed shortly. But you might be able to get it to work with conditional logic formulas

If I knew what a conditional logic formula was I wouldn't be asking now would I

<wanders off to YouTube>

 

[two sheds]

IF (D3=Y, C3+65, C3+25)

that sort of thing? Or am I misunderstanding?

 

[Supine]

If cell is y then, if…

 

[a_chap]

Is "Numbers" an Excel thing?

If not, would someone please be good enough to enlighten me?

 

[two sheds]

yes I'm assuming

Excel, Else (what Supine said)

 

[High Voltage]

Is "Numbers" an Excel thing?

If not, would someone please be good enough to enlighten me?

Nope numbers is the Mac equivalent of excel

Some of the answers given I’m pretty sure I’ve tried and “it” doesn’t like the use of a Y

But I’ll try again when I get home

 

[two sheds]

I'd do a lower case y myself otherwise lots of unnecessary caps key

 

[High Voltage]

I'd do a lower case y myself otherwise lots of unnecessary caps key

Fairly sure I tried both, to no avail
Will try again this afternoon

 

[High Voltage]

Hmmm - not working - can't just put in "y"



I've "got" a solution but my god doesn't it go around the houses

There must be an easier way

 

[existentialist]

Nope numbers is the Mac equivalent of excel

Some of the answers given I’m pretty sure I’ve tried and “it” doesn’t like the use of a Y

But I’ll try again when I get home

You're going to need to quote that "Y"

if(C7="Y", C3+25, C3+60)

(your values may vary)

 

[A380]

In Excel I’d use a drop down menu for Yes or No then an If (D4“Yes”, D2+35, blah blah) . Would spend up data entry and also avoid case issues.

 

[Puddy_Tat]

In Excel I’d use a drop down menu for Yes or No then an If (D4“Yes”, D2+35, blah blah) . Would spend up data entry and also avoid case issues.

I'd agree.

If you leave it as free field, some people will type any of Y, y, yes, Yes (and equivalents for no) or any old cobblers instead. Or might put a space before or after the Y.

At the very least, have something that comes up with an error message if they put something not valid there.

 

[two sheds]

Fair points those - I've only ever done spreadsheets for my own use, and even then I do sometimes forget about minor points like case.

 

[2hats]

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

 

[A380]

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

Yes, spend 5 minutes on that and two hours on choosing the colours for conditional formatting to make sure it looks pretty was always my excel way.

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 …

 

[farmerbarleymow]

I'd do a lower case y myself otherwise lots of unnecessary caps key

Yes, pressing the caps lock key or shift is just so strenuous isn't it?

 

[A380]

Yes, pressing the caps lock key or shift is just so strenuous isn't it?

There’s someone who’s always had a minion to do data entry for them…

 

[High Voltage]

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

 

[farmerbarleymow]

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

Are you not having any joy then?

 

[High Voltage]

well, I'll go to the foot of our stairs

whilst juggling a cat it now seems to work

thank you one and all

 

[High Voltage]

Are you not having any joy then?

and you can fuck the fuck off 'n' all

 

[two sheds]

You've not thought of moving to Excel or LibreOffice?