If then formula how to#
If then formula plus#

I have tried the simple example presented in this discussion and also I get 'Syntax error'. I have quitted the Application and started it again, started a spreadsheet from scratch, and I've restarted the computer and always get the same error.

I was trying to use formulas with function 'IF' copying exactly as Apple examples but I always get 'syntax error'. The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. I have used formulas before with o problem. I'm not an advance user of Numbers 09, but I'm not a beginner either. I lost about 3 hours and I was really getting MAD with Apple Numbers 09 For the result you want, MIN makes much more sense than IF, so I'd second Wayne's proposed formula. One thing that search would not have produced in this case, though, is the suggestion made by Wayne to use MIN instead of IF. Click each segment in turn and write that part in. Select one, and the bottom part of the browser window gives you a description, including the syntax, for that function.Ĭlick Insert Function and the browser inserts the function, with its syntax shown, into the selected cell.

If then formula plus#

You'll get a list of all the functions that include the letter string you typed, plus other functions whose purpose is similar in some way. Type the name (or part of the name) of the function you want in the search box. Click the yellow Function button in the Toolbar and choose Show Function Browser. Or you could use the Function Browser (without even leaving numbers). Starting there will point you to the page describing the function you're looking for AND show you some others you might not have considered.

If then formula how to#

A search for IF brings up a huge number of hits, of course ('if' is a very common word in this guide), but the one pointing to the Table of contents entry (on page 6) is third on the list, and not very hard to spot.Ĭlicking that will take you to the contents page section listing the Logical and Information functions, where clicking on the IF entry will take you to the article on this function, where you'll find a description, a statement of the syntax (not quite as easy to read as Jason's version), and an example or two of how to use the function.įor individual functions, though you might want to skip the search and go straight to the contents pages' list of functions, grouped by type. IF, and all the rest of the functions supported by the iWork applications, is defined and discussed in the iWork Formulas and Functions User Guide.