Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is true
I want to copy a value cell B2 into cell B3 IF a value in B1 is true.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is true
In B3, use the formula =IF(B1,B2,"") , assuming that you want B3 to be blank
if B1 is false. -- David Biddulph "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is true
In B3 put the following formula:
=If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is true
in B3 put
=IF(B1=TRUE,B2,"") lespal wrote: I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
Thanks Bob,
My question was not clear. I need to copy the value contained in cell B2 into B3 if the value in B1 is true. Les Palmer "Bob Flanagan" wrote: In B3 put the following formula: =If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
Thanks David.
My question was not clear. I need to copy the value in cell B2 into B3 if the value in B1 is true. Les Palmer "David Biddulph" wrote: In B3, use the formula =IF(B1,B2,"") , assuming that you want B3 to be blank if B1 is false. -- David Biddulph "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
Bob's formula does that, though it assumes that by True you mean TRUE< a
non-zero number, or blank. But your followup isn't any more clear. Perhaps more explicitly: B3: =IF(B1=TRUE,B2,"") If you have other requirements, you might be more give more detail In article , lespal wrote: Thanks Bob, My question was not clear. I need to copy the value contained in cell B2 into B3 if the value in B1 is true. Les Palmer "Bob Flanagan" wrote: In B3 put the following formula: =If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
Thanks JE,
I am afraid this formula does not do what I need. Cell B1 contains 1 Cell B2 Contains 25 My idea was : =(IFB1=1,"B2","") if true display the contents of cell B2 in cell b3 and if false leave cell B3 blank. The problem is that B2 is displayed and not the contents of cell B2. I hope this is clearer! Thanks to all who replied, Les Palmer "JE McGimpsey" wrote: Bob's formula does that, though it assumes that by True you mean TRUE< a non-zero number, or blank. But your followup isn't any more clear. Perhaps more explicitly: B3: =IF(B1=TRUE,B2,"") If you have other requirements, you might be more give more detail In article , lespal wrote: Thanks Bob, My question was not clear. I need to copy the value contained in cell B2 into B3 if the value in B1 is true. Les Palmer "Bob Flanagan" wrote: In B3 put the following formula: =If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
To "copy" B2 content without having a formula in B3 would require VBA code.
Formulas cannot copy to a blank cell. Gord Dibben MS Excel MVP On Thu, 24 May 2007 07:06:00 -0700, lespal wrote: Thanks Bob, My question was not clear. I need to copy the value contained in cell B2 into B3 if the value in B1 is true. Les Palmer "Bob Flanagan" wrote: In B3 put the following formula: =If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
You have "B2" in quotes so Excel will return that as a text string.
Re-write as =IF(B1=1,B2,"") or as per the other example you received. Gord Dibben MS Excel MVP On Thu, 24 May 2007 07:58:04 -0700, lespal wrote: Thanks JE, I am afraid this formula does not do what I need. Cell B1 contains 1 Cell B2 Contains 25 My idea was : =(IFB1=1,"B2","") if true display the contents of cell B2 in cell b3 and if false leave cell B3 blank. The problem is that B2 is displayed and not the contents of cell B2. I hope this is clearer! Thanks to all who replied, Les Palmer "JE McGimpsey" wrote: Bob's formula does that, though it assumes that by True you mean TRUE< a non-zero number, or blank. But your followup isn't any more clear. Perhaps more explicitly: B3: =IF(B1=TRUE,B2,"") If you have other requirements, you might be more give more detail In article , lespal wrote: Thanks Bob, My question was not clear. I need to copy the value contained in cell B2 into B3 if the value in B1 is true. Les Palmer "Bob Flanagan" wrote: In B3 put the following formula: =If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
Hi
You have your bracket in the wrong place, which I assume is a typo, not a copied formula. You will see B2 in cell B3, because you have put quotes around the value, therefore you are telling Excel to literally use "B2" =IF(B1=1,B2,"") David's initial response would have done the same - had you tried it. -- Regards Roger Govier "lespal" wrote in message ... Thanks JE, I am afraid this formula does not do what I need. Cell B1 contains 1 Cell B2 Contains 25 My idea was : =(IFB1=1,"B2","") if true display the contents of cell B2 in cell b3 and if false leave cell B3 blank. The problem is that B2 is displayed and not the contents of cell B2. I hope this is clearer! Thanks to all who replied, Les Palmer "JE McGimpsey" wrote: Bob's formula does that, though it assumes that by True you mean TRUE< a non-zero number, or blank. But your followup isn't any more clear. Perhaps more explicitly: B3: =IF(B1=TRUE,B2,"") If you have other requirements, you might be more give more detail In article , lespal wrote: Thanks Bob, My question was not clear. I need to copy the value contained in cell B2 into B3 if the value in B1 is true. Les Palmer "Bob Flanagan" wrote: In B3 put the following formula: =If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a value in say B2 in B3 IF a value in B1 is tr
Hi,
I have finally got it!! Many thanks to all who took the time to reply. Les Palmer "Roger Govier" wrote: Hi You have your bracket in the wrong place, which I assume is a typo, not a copied formula. You will see B2 in cell B3, because you have put quotes around the value, therefore you are telling Excel to literally use "B2" =IF(B1=1,B2,"") David's initial response would have done the same - had you tried it. -- Regards Roger Govier "lespal" wrote in message ... Thanks JE, I am afraid this formula does not do what I need. Cell B1 contains 1 Cell B2 Contains 25 My idea was : =(IFB1=1,"B2","") if true display the contents of cell B2 in cell b3 and if false leave cell B3 blank. The problem is that B2 is displayed and not the contents of cell B2. I hope this is clearer! Thanks to all who replied, Les Palmer "JE McGimpsey" wrote: Bob's formula does that, though it assumes that by True you mean TRUE< a non-zero number, or blank. But your followup isn't any more clear. Perhaps more explicitly: B3: =IF(B1=TRUE,B2,"") If you have other requirements, you might be more give more detail In article , lespal wrote: Thanks Bob, My question was not clear. I need to copy the value contained in cell B2 into B3 if the value in B1 is true. Les Palmer "Bob Flanagan" wrote: In B3 put the following formula: =If(B1, B2, "") Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "lespal" wrote in message ... I want to copy a value cell B2 into cell B3 IF a value in B1 is true. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display TRUE / FALSE Instead Of 1 / 0 | Excel Discussion (Misc queries) | |||
IF or similar but true result to display in consecutive row | Excel Worksheet Functions | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Excel: with an if condition display a row of cell if true | Excel Discussion (Misc queries) | |||
How do I stop Excel from changing the word true to TRUE? | Excel Discussion (Misc queries) |