| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if false return a zero
i have the following formula that compares values between two worksheets. If
the value is true it returns the value on a specific cell. If the value is false, it is returning a blank but I need it to return a zero instead. I can't for some reason make it work...anyone has any idea why? =IF($A8=INDIRECT("[SDS2005CE.xls]we"&$BU8&"!$L$3"),INDIRECT("[SDS2005CE.xls]we"&$BU8&"!N"&COLUMNS($A$1:E5)+16),0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding True False Results | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
| Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
| Paste Special in a macro | Excel Worksheet Functions | |||
Threaded Mode
