if false return a zero

[Guest]

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)

 

[Max]

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 <at>yahoo<dot>com
----

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)

 

[Dave Peterson]

Your formula looks ok to me.

What happens if you select that cell, hit F2, then F9.
(Hit edit|undo after you see the results.)

And if you highlight just this portion:
$A8=INDIRECT("[SDS2005CE.xls]we"&$BU8&"!$L$3")
and hit F9, what do you see.

Along with Max's suggestion (checking tools|options|view tab|0's), how about
Format|conditional format (white font on white fill)???

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)

 

[Guest]

Guys,

Thank your for all of your help!!!

Your formula looks ok to me.

What happens if you select that cell, hit F2, then F9.
(Hit edit|undo after you see the results.)

And if you highlight just this portion:
$A8=INDIRECT("[SDS2005CE.xls]we"&$BU8&"!$L$3")
and hit F9, what do you see.

Along with Max's suggestion (checking tools|options|view tab|0's), how about
Format|conditional format (white font on white fill)???

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)