| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why doesn't this work !!
Hi,
I have a formula in worksheet 'stats' cell F8 which is =IF('Log '!W8=0,"",'Log '!W8) as 'Log' W8 is showing zero the result in Stats F8 is a blank cell. so I have the same formula in worksheet stats cell G8 =IF('Log '!Y8=0,"",'Log '!Y8) as 'Log' Y8 is showing zero why is the result in Stats G8 a zero and not a blank?? thanks |
|
#2
|
|||
|
|||
|
Hi Anthony,
Y8 may be *showing* a zero, but it may actually be something like 0.0000000000001 Widen the cell or try multiplying by 1000000000 to see what's in there Niek Otten "Anthony" wrote in message ... Hi, I have a formula in worksheet 'stats' cell F8 which is =IF('Log '!W8=0,"",'Log '!W8) as 'Log' W8 is showing zero the result in Stats F8 is a blank cell. so I have the same formula in worksheet stats cell G8 =IF('Log '!Y8=0,"",'Log '!Y8) as 'Log' Y8 is showing zero why is the result in Stats G8 a zero and not a blank?? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| Erase & Draw Border functions no longer work | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
| Service work order | Charts and Charting in Excel | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Linear Mode
