Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

Excel Question Twelvty Hundred


libero

Recommended Posts

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

Link to comment
Share on other sites

i'm on the dutch version of excel mate, i'm translating the syntax as i would do it

 

you could try this

=IF(AND(X6<>0,X6=Y6)=true,100,0)

over here we use a ; instead of a , as a separator, so you could try using them depending on your excel version

else ask Leo, he knows all about X6

Link to comment
Share on other sites

i'm on the dutch version of excel mate, i'm translating the syntax as i would do it

 

you could try this

=IF(AND(X6<>0,X6=Y6)=true,100,0)

over here we use a ; instead of a , as a separator, so you could try using them depending on your excel version

else ask Leo, he knows all about X6

 

 

Not happenin mate, thanks anyhoos.

 

Excel 2007 here.

Link to comment
Share on other sites

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

 

Probably a long winded way of doing this...

 

=IF(X6>0,IF(Y6>0,IF(X6=Y6,100,0),""),"")

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...