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)

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)

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)???



outlook help wrote:

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

Guys,

Thank your for all of your help!!!

"Dave Peterson" wrote:

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)???



outlook help wrote:

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