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.

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

User profile for user: LynnFarr
LynnFarr Author
User level: Level 1
4 points

syntax error copying formula from Excel to Numbers

I am not good with writing formulas (IF, THEN statements in particular) I have copied this formula from EXCEL am getting a syntax error. I have no idea where to do from here. thank you in advance! Taking a total from the line and needing to place a value in the next column


IF(I2=0,"10.0",I2<1,"9.9",I2<2.6,"9.8",I2<4.1,"9.6",I2<6.1,"9.4",I2<8.1,"9.2",I2<10.1,"9.0",I2<15.1,"8.5",I2<20.1,"8.0",I2<25.1,"7.5",I2<30.1,"7.0",I2<35.1,"6.5",I2<40.1,"6.0",I2<45.1,"5.5",#,I2<50.1,"5.0",I2<55.1,"4.5",I2<60.1,"4.0",I2<65.1,"3.5",I2<70.1,"3.0",I2<75.1,"2.5",I2<80.1,"2.0",I2<85.1,"1.5",I2<90.1,"1.0",I2>90,".5")

Mac mini (M2, 2023)

Posted on Aug 2, 2024 10:12 AM

Reply
Question marked as Top-ranking reply
User profile for user: 6x6
6x6
User level: Level 6
15,698 points

Posted on Aug 2, 2024 10:57 AM

Use the IFS function instead.

View in context
3 replies
User profile for user: Badunit
Badunit
User level: Level 7
28,324 points

Aug 2, 2024 12:26 PM in response to LynnFarr

That is not a proper IF formula and would not have worked in Excel. Replace the IF with IFS.


Also, if what you posted was the entire formula you copy/pasted from Excel, it needs a comma, one more result, and a closing paranthesis on the right. They may have gotten truncated when you posted due to how long the formula is. I can't see them in your post.

Reply

syntax error copying formula from Excel to Numbers

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