| 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! |
| 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 | |||
Threaded Mode
