Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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]

Posted on Aug 17, 2024 4:02 AM

Reply
6 replies

Aug 17, 2024 9:06 AM in response to LynneAlison

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.


Aug 17, 2024 3:52 PM in response to LynneAlison

=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)

Aug 17, 2024 12:33 PM in response to Badunit

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.

How can I implement conditional calculations in Numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.