| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula returning a blank cell
In cell c1 I have the formula =IF(A10,B1)
In cell B1 I have the words "count costs" I want cell C1 to return the words "count costs" when A1 is greater than 0 (that works fine). But if the volue in A1 = zero I want C1 to return a blank cell. TIA for any help -- bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying non-returning formula (blank Cell) | Excel Worksheet Functions | |||
| Formula returning a blank cell if answer is zero | Excel Discussion (Misc queries) | |||
| returning blank when reference cell is blank | Excel Worksheet Functions | |||
| returning blank cell | Excel Worksheet Functions | |||
| returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
Threaded Mode
