How can I implement conditional calculations in Numbers?
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]
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?