Excel 2007 : Remove zero awaiting IF implementation

[13sydwest]

I want to show in cell D6 the value in cell C6 if values in B6 and C6 are the same; if they are different, I want D6 blank. To do this I use in D6 the formula: =IF(B6=C6,C6,""). All this works fine; however, until some value is entered into either B6 or C6, D6 now has "0" in it. Is there any way of having the "0" not appear in cell D6?

[abousetta]

Hello and welcome to the forum,

All you need is another nested IF statement. Untested but should work:

Please Login or Register  to view this content.

Hope this helps.

abousetta

[teylyn]

Hello,

you could add a condition to the formula that will test the total length of the characters

=IF(AND(LEN(B6&C6)>0,B6=C6),C6,"")

Or you could use a custom format to suppress zero values (but that would also suppress a 'legitimate' 0 value, when both cells contain a 0)

General;;;@

[13sydwest]

Hello and welcome to the forum,

All you need is another nested IF statement. Untested but should work:

Please Login or Register  to view this content.

Hope this helps.

abousetta

Many thanks - works perfectly
13sydwest

[13sydwest]

Hello,

you could add a condition to the formula that will test the total length of the characters

=IF(AND(LEN(B6&C6)>0,B6=C6),C6,"")

Or you could use a custom format to suppress zero values (but that would also suppress a 'legitimate' 0 value, when both cells contain a 0)

General;;;@

Many thanks - works perfectly
13sydwest

[abousetta]

Hi,

Glad we were able to help. If you are satisfied with the results, please mark the thread as [SOLVED] (next to the title on the first post). Also positive recognition (scales) are always welcomed. If you have any further questions, please re-post.

If want to mark the post as solved then:

1) Click the Edit button on your first post in the thread
2) Click Go Advanced
3) select [SOLVED] from the Prefix dropdown
4) click Save Changes

Good luck.

abousetta