Sun, 3 Feb 2008 19:53:01 -0800 from David franklin
:
Sorry if question is not clear. if cell is 48" or less I want to add 3" to
the cell examples (48+3=51) (25 + 3 =28) if cell is 49 or greater the I want
to add 6" to cell (50 +6 =56) ... in one cell (c11) I will put the number in
a different cell (D15) I want the answer
=if(C11<=48,C11+3,C11+6)
Note that you *still* have not specified what to do if the number is
between 48 and 49, so it's possible the above won't do what you want
if C11 is 48.2.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?