Create IF formula using NUMBERS

Hi adyleroux.

I think your basic issue here is that you want "this cell" to contain both a fixed value and a formula which will add the value in a second cell to 'this cell's' value under a specific condition.

Cells can contain an entered value, or can contain a forwula which calculates a value, but cannot contain both.

If a cell contains a fixed value, then placing a formula in that cell replaces the fixed value with the formula.

If a cell contains a formula, then entering a fixed vlue in that cell replaces the fornula.

To make this work, you need to place the fixed value in a separate cell or write it into the formula itself.

Here are two examples.

The first example contains the base amount in C2, and the amount to be added to that amount in C3.

The Popup menu is in cell A2, and the formula calculating the result is in B2

The second example uses the same cells for the popup menu and the result, but contains the base value and the bonus for Ady in the formula.

The formula inB2 of each example is shown below its table.

Regards,

Barry

I wonder what language would be like if it was not ambiguous. I interpreted "add to this cell" as "put in this cell".

Or these two classics:

A ship-shipping ship shipping ship-shipping ships

Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo

Yeah, that second one is grammatically correct.

Three meanings of the word:

Buffalo the city.

Buffalo the animal. Used as plural here.

Buffalo "to confuse or deceive".

"Buffalo bufallo" are bufalloes from Buffalo

Switching the words around a little (moving the capitalized ones around) and adding a few words:

Buffalo from Buffalo that [other] buffalo from Buffalo bufallo [also] buffalo buffalo from Buffalo

It is a dumb sentence for sure

I got this from an Australian source that may thus be describing a separate language😀, but other valid examples of sentences "in English" supposedly include:

Police police Police police police police Police police.

Can-can can-can can can can can can-can.

SG

Hi SG,

SGIII wrote:

Police police Police police police police Police police.

Can-can can-can can can can can can-can.

No, I can't translate into "Strayan" (Australian).

Mairzy doats and dozy doats and liddle lamzy divey

A kiddley divey too, wouldn't you?

Regards,

Ian.

Better in (one of) the original version(s) from 1944, such as this one by The Merry Macs, and weirder in this version by Spike Jones.

Now can you parse these two?

Police police Police police police police Police police.

Can-can can-can can can can can can-can.

B.

Police police appears to be the same pattern as Buffalo buffalo.

Police from the town of Police who are policed by police from the town of Police, police the police from the town of Police.

I am lost on can-can.

The solution I suspect depends on the difference meanings of can - is able to, to get rid of, and the dance.

But don't ask me. Ask Ian. I got it from an Australian source so I think it's Australian.😀

SG

Hi BU,

I understand this

A ship-shipping ship shipping ship-shipping ships

However, "Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo" has me completely puzzled.

Regards,

Ian.

If the pop up menu if in cell A1 ("cell 1") and the number to be "added" is in cell A2 ("cell 2"), the formula for A3 ("this cell") would be

=IF(A1="Ady", A2, "what to do if A1 is not Ady")

"It is a dumb sentence for sure"

Had me buffaloed.

Barry

If the words sound funny and queer to the ear...

I found it (I think)! Mairzy Doats

SG

I've had that song in my head all morning since reading Ian's post. My mom used to sing that first unintelligible line every once in a while and I never knew what it was about until today.