iWorks Numbers: how set an if/then condition?

[mrzeigler]

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.

 

[jacg]

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.

 

[LongSticks]

Should work

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.

For anybody else!

=if(e1="Y", L1-I1,"0")

=(conditional, if true, if false)

 

[saberahul]

syntax is generally similar to that of excels. googling if/then + excel will be of help to anyone else with similar questions.

 

[neutrino23]

Or just search through the help documentation provided with Numbers. They include examples for nearly all functions.