Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 284
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 284
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbe trying to do Dynamic Parameters from a Worksheet Sean Cooper Excel Discussion (Misc queries) 0 January 22nd 07 02:56 PM
Newbe looking for info on dymaic queries in Excel Sean Cooper Excel Discussion (Misc queries) 0 January 22nd 07 02:50 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
Newbe help with a lookup Cybertech Excel Discussion (Misc queries) 2 January 13th 06 09:53 PM
Newbe Help with count/countif function Cybertech Excel Worksheet Functions 5 August 24th 05 03:48 AM


All times are GMT +1. The time now is 05:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"