Thread: Excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default Excel formula

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?