IF, THEN

Giganews Newsgroups
Subject: IF, THEN
Posted by:  Gale Gorman (ggorm…@houston.rr.com)
Date: Fri, 24 Oct 2003

I would like to embed an "if" statement in a cell but don't
know the syntax.

My example is from D1 write the following:

(if (A1 > 0)(A1 / C1) (if (B1 > 0)(B1 / C1)))

I am assuming that if the first "IF" fails, the "THEN" part
will go to the next "IF" statement.

Thanks in advance,

Gale Gorman
Houston

Replies