Excel Question Twelvty Hundred

[libero]

All hail sages of the genny...

 

Two lines of cells if one equals the other 100% if not 0%...simple.

 

=IF(X6=Y6,100,0)

 

The two lines fill from other cells info filled in by others.

But what if there is nothing at all in the original 2 cells, then cells are equal hence 100%, thats baws I want 0.

 

Please help an excel novice in his hour of need : )

[surf]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[libero]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[surf]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[libero]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[surf]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here