MacOS – Nested IF statement in Numbers

macosnumbers

I am working on a table to tabulate mileage costs for my small business. I have 3 destinations I go to on a regular basis. I would like the address to automatically populate in the C cell if the expression is met in the B cell.

I have copied numerous equations from various websites, but have not been able to get any of the equations to work. The latest is pasted below.

IF((B88="SHADY GROVE METRO","15903 SOMMERVILLE DR",IF((B88="POR TRAIN STATION","CLAY STREET",IF(B88="BWI","7062 ELM ROAD",""))))))

Am I even close?

Best Answer

It looks like you have a lot of extra parenthesis everywhere... give this a try.

IF(B88="SHADY GROVE METRO","15903 SOMMERVILLE DR",IF(B88="POR TRAIN STATION","CLAY STREET",IF(B88="BWI","7062 ELM ROAD","")))

To provide a bit more detail, for every left paren (, you need a matching right paren ) to close the expression. Counting what you've shown, you have 5 left parens, and 6 right parens. This would likely cause an error due to the mismatch.

Additionally, each expression only needs one left paren to start it, not two.

Related Solutions

Numbers: How to write between in an IF statement

Try this way:

IF(D≥66.6%,"High",IF(D<=33.3%,"Low","Medium"))

enter image description here

MacOS – Open new Numbers document in older Numbers

This is a hack, but assuming that your document won't be damaged by undergoing some slight changes, here is what I would do.

Logon to www.iCloud.com, and open Numbers. If it isn't there, go to beta.iCloud.com.
Upload the new Numbers document to iCloud and then open the document in your browser.
Select Download a Copy from the settings menu (as seen in the screenshot below) and choose to save it as a Word document.
Open the Word document in Numbers and save/export in whatever format you wish.

Download a Copy

Alternate Approach:

You could, depending on the nature of the document, send it to a friend who has Yosemite and ask them to export it to the Numbers '09 format.

Other Options:

If I were you, and did want to mess with importing/export I'd probably try CloudConvert.com.
This article claims you may be able to revert the document, although the fact that you can't open it in the first place would seem to negate that option.

Best Answer

Related Solutions

Numbers: How to write between in an IF statement

MacOS – Open new Numbers document in older Numbers

Alternate Approach:

Related Question