Microsft excel return a zero value instead of a blank cell 1

[raheenray]

Hi

I have a large spreadsheet with multiple tabs. I have an if formula which returns a blank cell instead of "0". How do i get the formula to return zero value instead of a blank cell? My If formula is below:

=IF(INDEX('Civil Transmit RECORD'!$D$31:$CI$2534,MATCH('Transmittal CIVIL'!B23&'Transmittal CIVIL'!C23,'Civil Transmit RECORD'!$D$31:$D$2534,0),MATCH('Transmittal CIVIL'!$J$7,'Civil Transmit RECORD'!$D$31:$CI$31,0))=0, " ", INDEX('Civil Transmit RECORD'!$D$31:$CI$2534,MATCH('Transmittal CIVIL'!B23&'Transmittal CIVIL'!C23,'Civil Transmit RECORD'!$D$31:$D$2534,0),MATCH('Transmittal CIVIL'!$J$7,'Civil Transmit RECORD'!$D$31:$CI$31,0)))

Any help is appreciated.

Ray

 

[combo]

You have " " as a result if the condition is satisfied, change it to 0.

combo

 

[kjv1611]

Have you tried changing the cell number format to Number? You can adjust the decimal places to 0 as well if you're looking for integers only. I think that will do it, but I suppose I'd have to test with your formula to verify.

Or another method could be to embed all of that within an IF function, but that would add performance lag, b/c it'd have to basically run your current formula twice.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

Hi,

Please be precise, for your own good!

Your formula is not returning a BLANK, it is returning a SPACE, as combo pointed out to you.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

Wow, I guess I didn't want to take the time to read the whole formula. And now it's right in front of me. Of course, if I'd of refreshed the page before hitting "submit" I'd of seen combo's post.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[raheenray]

Thanks a lot for your replies. I see the problem now.