iPad Numbers Assistance

[pstar]

I'm using iPad numbers and need help writing an IF equation. Basically I would like a value in one cell to result in another cell being filled with one of four word. Here goes my poorly written example (hope it makes sense)

if A1 has a value over 12,000 A2 should read "Word1" but if it's under 12,000 but over 6,000 A2 should read "Word2" but if it's under 6,000 but over 2,000 A2 should read "Word3" but if it's under 2,000 A2 should read "Word4"

Thats at the best way I can explain it. Any assistance would be appreciated.

 

[twerppoet]

The structure of a an IF statement is IF (if-expresion), (is-true), (is-false)

The way you handle multiple choices is with nested IF statements. Your first IF statement checks to see if the value is over 12,000. If true it assigns Word1, if false then you use a second IF statement to check if the value is over 6000. If it is, then you assign Word2, if not then you use an IF Statement to check if the value is over 2000. Again, if true you assign Word3. Since any remaining value must be equal to or less than 2000, instead of another IF statement you assign Word4 as the not-true choice.

While the concept is fairly straight forward, the result looks messy, and you have to keep close track of what you are doing. Here is a screenshot of how it will look.

If you need more detailed help creating the forumula, let me know.

 

[pstar]

I thought I understood...I'll gladly take more help if you don't mind...

 

[twerppoet]

No problem, but it will take a bit of time to put it together. Give me an hour or so.

 

[pstar]

Thanks

 

[twerppoet]

Ok, here we go. A step-by-step on how to enter the formula.

There are a lot of screenshots (it's all annotated screenshots), so I'll break it into a couple of posts to keep the image load managable.

--------------

--------------

--------------

--------------

--------------

 

[twerppoet]

--------------

--------------

--------------

Note: That should have said the Greater Than sign.

--------------

 

[twerppoet]

--------------

--------------

--------------

--------------

--------------

 

[pstar]

Super grateful...... got it done thanks a ton.

 

[twerppoet]

No problem. Glad to help.

 

[giradman]

No problem. Glad to help.

Hi TP - outstanding effort in putting together that complex formula - the OP was lucky that you were around to help - congrats and mucho pats on the back! Dave

 

[twerppoet]

Hi TP - outstanding effort in putting together that complex formula - the OP was lucky that you were around to help - congrats and mucho pats on the back! Dave

Thanks. I'm pretty used to dealing with nested IF statements in both spreadsheets and programing, so the hardest part was getting all the screenshots and annotations in order.

 

[brixtonboy]

Wow l have no idea what that was all about, but you did a fantastic job for the original poster congratulations

 

[Catmilk]

Hi there. Can any one help me with a formular. I have a row of numbers. I want to be able to add the date I do an item under it and this date will trigger the numbers to Sum at the end of a row. Here is what I have so far, please don’t laugh I’m a scaffolder. Lol

 

[twerppoet]

The conditional part of the formula is a text field. You don’t (can’t) use a cell/selection to fill it. Tap the Text entry button and create the conditional that way. Example below.