| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Put Results in another cell
OK guys/gals -
I know this MUST be simple, but I'm very new to excel. I'm trying to look at one column (A), if the work "Dist" or "Sale" is in the Cell, I would like to fill the next column (B) with "--", otherwise, leave the values alone in column B. =IF(OR(A1="Dist",A1="Sale"),B1="'--", otherwise leave value alone in B1 Thanks for everything! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to refer the results of one cell to another cell? | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| Search Range for Criteria in given cell and produce results | Excel Discussion (Misc queries) | |||
| VLOOKUP - results do not appear in cell | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Threaded Mode
