| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format - Copy a cell instead of "true"
Hi Folks
I am working on a spreadsheet and am using this formula: =IF(E2="Purchases","Yes"," ") As you know if the cell E2 contains the work purchases, this cell will display the word Yes. I actually want the cell this formula is in (G2) to display the value that is located in cell F2 instead of Yes. Is this even possible, i've tried several options but obviously don't have the knowledge to work this one out myself. Any help would be greatly appreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format - Copy a cell instead of "true"
Try it like this:
=IF(E2="Purchases",F2,"") Notice how I removed the space between the quotes at the end of the formula. -- Biff Microsoft Excel MVP "Colinbonnes" wrote in message ... Hi Folks I am working on a spreadsheet and am using this formula: =IF(E2="Purchases","Yes"," ") As you know if the cell E2 contains the work purchases, this cell will display the word Yes. I actually want the cell this formula is in (G2) to display the value that is located in cell F2 instead of Yes. Is this even possible, i've tried several options but obviously don't have the knowledge to work this one out myself. Any help would be greatly appreciated! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format - Copy a cell instead of "true"
I started with no space at the end and i've changed it in one of my dozens of
attempts to get it to work. Obviously i hadn't tried this solution cos it worked brilliantly. Wish I'd asked an hour ago. Thanks for your help "T. Valko" wrote: Try it like this: =IF(E2="Purchases",F2,"") Notice how I removed the space between the quotes at the end of the formula. -- Biff Microsoft Excel MVP "Colinbonnes" wrote in message ... Hi Folks I am working on a spreadsheet and am using this formula: =IF(E2="Purchases","Yes"," ") As you know if the cell E2 contains the work purchases, this cell will display the word Yes. I actually want the cell this formula is in (G2) to display the value that is located in cell F2 instead of Yes. Is this even possible, i've tried several options but obviously don't have the knowledge to work this one out myself. Any help would be greatly appreciated! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format - Copy a cell instead of "true"
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Colinbonnes" wrote in message ... I started with no space at the end and i've changed it in one of my dozens of attempts to get it to work. Obviously i hadn't tried this solution cos it worked brilliantly. Wish I'd asked an hour ago. Thanks for your help "T. Valko" wrote: Try it like this: =IF(E2="Purchases",F2,"") Notice how I removed the space between the quotes at the end of the formula. -- Biff Microsoft Excel MVP "Colinbonnes" wrote in message ... Hi Folks I am working on a spreadsheet and am using this formula: =IF(E2="Purchases","Yes"," ") As you know if the cell E2 contains the work purchases, this cell will display the word Yes. I actually want the cell this formula is in (G2) to display the value that is located in cell F2 instead of Yes. Is this even possible, i've tried several options but obviously don't have the knowledge to work this one out myself. Any help would be greatly appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| how to use "if" logical argument to format/copy some pic. in cell | Excel Worksheet Functions | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
