Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbe with a formula question.
if cell c11 is 48" or less I want to add 3" to
the cell D15 examples (48+3=51) (25 + 3 =28) if cell c11 is 49 or greater the I want to add 6" to cell d15 (50 +6 =56) ... example in one cell (c11) I will put the number 50 in I want cell (D15) to give me the answer 56. if in the same cell(c11) i put 28 I want to see in cell D15 the answer 31 Can this be done and if so can I get the formula to do so. Please |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbe with a formula question.
David
=IF(C11=49,C11+6,C11+3) It would be to your benifit to NOT multi post. Those answering questions in this forum will follow your thread if you stick with it. If the response is not working for you please tell us why and what you may need changed to get what you want. You have responses in your other thread. Mike Rogers "David franklin" wrote: if cell c11 is 48" or less I want to add 3" to the cell D15 examples (48+3=51) (25 + 3 =28) if cell c11 is 49 or greater the I want to add 6" to cell d15 (50 +6 =56) ... example in one cell (c11) I will put the number 50 in I want cell (D15) to give me the answer 56. if in the same cell(c11) i put 28 I want to see in cell D15 the answer 31 Can this be done and if so can I get the formula to do so. Please |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbe with a formula question.
Sorry and thank you for your help
"Mike Rogers" wrote: David =IF(C11=49,C11+6,C11+3) It would be to your benifit to NOT multi post. Those answering questions in this forum will follow your thread if you stick with it. If the response is not working for you please tell us why and what you may need changed to get what you want. You have responses in your other thread. Mike Rogers "David franklin" wrote: if cell c11 is 48" or less I want to add 3" to the cell D15 examples (48+3=51) (25 + 3 =28) if cell c11 is 49 or greater the I want to add 6" to cell d15 (50 +6 =56) ... example in one cell (c11) I will put the number 50 in I want cell (D15) to give me the answer 56. if in the same cell(c11) i put 28 I want to see in cell D15 the answer 31 Can this be done and if so can I get the formula to do so. Please |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbe with a formula question.
David
Did not mean to sound like a nag so you don't need to apologize. I was just trying to help you understand some of the processes here and help you get an answer to your question!!! Thanks for the feed back Mike Rogers "David franklin" wrote: Sorry and thank you for your help "Mike Rogers" wrote: David =IF(C11=49,C11+6,C11+3) It would be to your benifit to NOT multi post. Those answering questions in this forum will follow your thread if you stick with it. If the response is not working for you please tell us why and what you may need changed to get what you want. You have responses in your other thread. Mike Rogers "David franklin" wrote: if cell c11 is 48" or less I want to add 3" to the cell D15 examples (48+3=51) (25 + 3 =28) if cell c11 is 49 or greater the I want to add 6" to cell d15 (50 +6 =56) ... example in one cell (c11) I will put the number 50 in I want cell (D15) to give me the answer 56. if in the same cell(c11) i put 28 I want to see in cell D15 the answer 31 Can this be done and if so can I get the formula to do so. Please |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbe with a formula question.
David, It would be to your benefit to put your solution on paper, developing
a formula that works and then read a beginner's book in Excel to find out to express your solution in Excel. For example, if on paper you add 3 to 2 and get 5, in Excel this is =3+2. The = says a formula follows. It's that easy. Tyro "David franklin" wrote in message ... if cell c11 is 48" or less I want to add 3" to the cell D15 examples (48+3=51) (25 + 3 =28) if cell c11 is 49 or greater the I want to add 6" to cell d15 (50 +6 =56) ... example in one cell (c11) I will put the number 50 in I want cell (D15) to give me the answer 56. if in the same cell(c11) i put 28 I want to see in cell D15 the answer 31 Can this be done and if so can I get the formula to do so. Please |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbe with a formula question.
Do not mulitpost.
Tyro "David franklin" wrote in message ... if cell c11 is 48" or less I want to add 3" to the cell D15 examples (48+3=51) (25 + 3 =28) if cell c11 is 49 or greater the I want to add 6" to cell d15 (50 +6 =56) ... example in one cell (c11) I will put the number 50 in I want cell (D15) to give me the answer 56. if in the same cell(c11) i put 28 I want to see in cell D15 the answer 31 Can this be done and if so can I get the formula to do so. Please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbe trying to do Dynamic Parameters from a Worksheet | Excel Discussion (Misc queries) | |||
Newbe looking for info on dymaic queries in Excel | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Newbe help with a lookup | Excel Discussion (Misc queries) | |||
Newbe Help with count/countif function | Excel Worksheet Functions |