What's new
Apple iPad Forum 🍎

Welcome to the Apple iPad Forum, your one stop source for all things iPad. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

iPad Numbers Assistance

pstar

iPF Noob
Joined
Feb 28, 2012
Messages
11
Reaction score
0
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

iPad Fan
Joined
Jan 8, 2011
Messages
24,150
Reaction score
15,397
Location
Milton-Freewater, OR
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.

IMG_1931-2.png
 
OP
P

pstar

iPF Noob
Joined
Feb 28, 2012
Messages
11
Reaction score
0
I thought I understood...I'll gladly take more help if you don't mind...
375f8b57bb9126c0d0acc2de1c316785.png
 

twerppoet

iPad Fan
Joined
Jan 8, 2011
Messages
24,150
Reaction score
15,397
Location
Milton-Freewater, OR
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.

IMG_1942-2.jpeg


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

IMG_1943-2.jpeg


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

IMG_1944-2.jpeg


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

IMG_1945-2.jpeg


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

IMG_1946-2.jpeg


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

IMG_1947.jpg
 
OP
P

pstar

iPF Noob
Joined
Feb 28, 2012
Messages
11
Reaction score
0
Super grateful...... got it done thanks a ton.
 

twerppoet

iPad Fan
Joined
Jan 8, 2011
Messages
24,150
Reaction score
15,397
Location
Milton-Freewater, OR
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. o_O
 

brixtonboy

iPF Novice
Joined
May 28, 2016
Messages
405
Reaction score
222
Wow l have no idea what that was all about, but you did a fantastic job for the original poster congratulations
 

Catmilk

iPF Noob
Joined
Oct 2, 2018
Messages
2
Reaction score
0
6B3837E1-57DA-4BE3-9CB0-4948586161BF.png
6B3837E1-57DA-4BE3-9CB0-4948586161BF.png
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
 

Attachments

  • B7D2EC60-2FCD-45AA-9F1C-91DD003872EE.png
    B7D2EC60-2FCD-45AA-9F1C-91DD003872EE.png
    193.8 KB · Views: 299

twerppoet

iPad Fan
Joined
Jan 8, 2011
Messages
24,150
Reaction score
15,397
Location
Milton-Freewater, OR
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.

A1852DFB-8B2B-4684-8FF6-657F86FED92D.jpeg
 

Most reactions

Latest posts

Top