| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b
Hi, using the following formula:
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) Problem is, if there is a blank cell in both a corresponding GB cell and FC cell, then it is returning 0 (zero). Likewise, when there is just a value in the GB cell e.g. 5.7, it is returning 5.7 as it is calling the blank cell as a zero. In both cases, I want it to return a blank cell (hence ""), as I am averaging the returning collumn and don`t want it to count blank cells as a value of 0. (I just don`t want them included). Hope this is clear guys (I`ve had a glass of wine!) Thanks RR1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| isna vlookup returning"0" instead of " " | Excel Worksheet Functions | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
| Returning a distance from a tabel, given "from" and "To"? | Excel Worksheet Functions | |||
Threaded Mode
