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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a Value IF a cell meets a criteria
Lets say your monetary sheet is named 'Sheet1'.
On your other sheet in the relevant cell type the formula: =IF(Sheet1!$C$4="","",1) In English: If On Sheet1! the Cell $C$4's Value is equal to "Nothing" then "Nothing" otherwise 1. Hope this helps. "ThunderStorm Studio" wrote: 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 |
Reply |
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 |