iWorks Numbers: how set an if/then condition?

M

mrzeigler

macrumors regular

Original poster

Oct 15, 2005

159

3

Pittsburgh

• Sep 7, 2013

• #1

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.

 

Last edited: Sep 7, 2013

jacg

macrumors 6502a

Jan 16, 2003

975

88

UK

• Sep 8, 2013

• #2

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.

 

L

LongSticks

macrumors 6502

Jul 22, 2012

301

0

Kent, UK

• Sep 8, 2013

• #3

Should work

mrzeigler said:

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.

Click to expand...

For anybody else!

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

=(conditional, if true, if false)

 

saberahul

macrumors 68040

Nov 6, 2008

3,645

111

USA

• Sep 8, 2013

• #4

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

 

N

neutrino23

macrumors 68000

Feb 14, 2003

1,881

391

SF Bay area

• Sep 9, 2013

• #5

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