You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I’m trying to create an if/then/else calculation for a personal financial spreadsheet. I want to accomplish… If A
[Re-Titled by Moderator]
Apparently it didn't all post. Below is what I intended to post.
I’m trying to create an if/then/else calculation for a personal financial spreadsheet. I want to accomplish… If A=“checking” then Z=X+Y else Z=Y. Is this possible?
The formula in the cell you are calling "Z" would be
=IF(A2="checking",X2+Y2, Y2)
assuming what you refer to as A", "X", and "Y" are cells A2, X2, and Y2.
You can use A, X, and Y without specifying a row number if they are all in the same row as the formula.
=IF(A="checking",X+Y,Y)
Note, though, that some formulas will treat a reference like "X" as "cell in column X of the current row" and others as the entire column X so you have to know what you are doing when you use this kind of cell referencing.
=IF(AND(A2="checking", B2="✔︎"),X2+Y2, Y2)
Or you could use the checkbox format for column B rather than a checkmark character. In that case it would be
=IF(AND(A2="checking", B2),X2+Y2, Y2)
Neither of these are the same as SUMIF, though. To make your SUMIF formula you would use SUMIFS instead. Using the checkbox format for B it would be
=SUMIFS(X, A, "checking", B, TRUE)
Looks like you didn't finish your post.
If A2>B2 then C2 else D2 would be
=IF(A2>B2, C2, D2)
What if I wanted to have two columns used as IFs. I want to reconcile the accounts using the name such as "checking" with another column containing "✔︎" when it has cleared.
In my previous spreadsheet incarnation, it was =SUMIF(column A,"✔︎checking",column X).
But, now that I'm running several accounts on one page, I'd like to have column for the account name and a separate column for the ✔︎.
I don't know if I'm explaining it sufficiently.
It worked! Thank you!
How can I implement conditional calculations in Numbers?
