Using numbers, I want to set up a formula to do the following: * If Column E = "Y," then subtract the value of column I from the value of column L. * If Column E is anything but a "Y", return a value of "0". I've never had to deal with a conditional in a formula before, and my searches keep revealing tips for conditional formatting. Any help would be appreciated. Thanks. UPDATE: Nevermind. I figured it out.
I'm not in front of numbers right now but have you tried entering... =if( Pretty quickly you should get screen tips advising you of the correct syntax. Good luck.
syntax is generally similar to that of excels. googling if/then + excel will be of help to anyone else with similar questions.
Or just search through the help documentation provided with Numbers. They include examples for nearly all functions.