| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
make cell show blank when total is zero
I think what the OP want to do is return a blank cell rather than 'hide' the result with text color. Alter your formula to this: =IF(COUNTIF(OFFSET('Daily MP'!$A:$A,0,MATCH(H$3,'Daily MP'!$5:$5,0)-1),"*" &$B8 & "*")=0,"",COUNTIF(OFFSET('Daily MP'!$A:$A,0,MATCH(H$3,'Daily MP'!$5:$5,0)-1),"*" &$B8 & "*")) should the result of your formula be zero, a blank cell will be the result, otherwise the result will be shown. Is this what you were looking for? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=543743 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Sum in first blank cell and a few more things... | Excel Discussion (Misc queries) | |||
| Making a particular cell or column required | Excel Discussion (Misc queries) | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
