| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a Value IF a cell meets a criteria
I must admit, it has been over three years since I worked with Excel, but I
thought it would be more like riding a bike going back into it. Situation: I have a workbook with three sheets in it. On one sheet, I have monetary figures, i.e., £450 in let's say cell C4, for argumentation. On another sheet, I want a 1 to appear in the C4 cell of THAT sheet if the cell in the monetary sheet is filled, and to remain blank if no input from the monetary sheet. The monetary sheet's cells all must maintain the £ symbol. Any help would be highly appreciated. Best Regards, Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find cell address that meets the criteria | Excel Discussion (Misc queries) | |||
| How can I get a cell to Flash if it meets a certain criteria in Ex | Excel Worksheet Functions | |||
| How do I go to the next cell that meets criteria | Excel Discussion (Misc queries) | |||
| Get data if cell within a row meets criteria | Excel Discussion (Misc queries) | |||
| how do I change the font of a cell if it meets a certain criteria. | Excel Worksheet Functions | |||
![ThunderStorm Studio[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
