Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |