Try a quick check to ensure zero values
are not suppressed on the sheet:
Click Tools Options View tab Check "Zero Values" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"outlook help" wrote in message
...
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)
|