Jump to content

Excel: 2 IF functions


Function

Recommended Posts

Hi everyone

 

I need to imply 2 "IF"-functions in one cell... Is this possible?

 

Consider 3 cells: A1, B1 and C1.

C1 should display "Yes" if A1 is larger than, or equal to one half of B1 AND it should display nothing if A1 is empty, but not zero (should A1 be zero, then C1 should be "No")!

Is this possible?

 

I tried on C1:

 

=IF(A1 >= (1/2)*B1);Yes;No) AND IF(A1 = "";"";"")

 

But this gives an error.

 

Can someone give me a line?

 

Thanks.

 

F.

Link to comment
Share on other sites

You can also directly copy and paste tables from html into excel.

 

Please quote my sentence that stated I wanted to do that.

There is none.

Ask before you insinuate.

 

There's no table I want to copy. It's a table I make myself, in order to have a nice view of my university results in juanuary/february for my former high school teachers ;)

Edited by Function
Link to comment
Share on other sites

 

You can also do: =AND(IF(A1 >= (1/2)*B1);Yes;No), IF(A1 = "";"";""))

 

Please stop posting irrelevant nonsense.

 

Doesn't work with me... Ah well, John provided me of an excellent answer. Thanks everyone for contributing to an enlightened mind :)

Link to comment
Share on other sites

 

Doesn't work with me... Ah well, John provided me of an excellent answer. Thanks everyone for contributing to an enlightened mind :)

 

Strange's code *) even works with Open Office, I just tried:

=AND(IF(A1=1;1;0);IF(B1=5;1;0))

 

But's harder than simply:

=IF(A1=1;IF(B1=5;1;0);0)

 

I attached OpenOffice doc:

test.zip

 

*)

OpenOffice has character ; to separate parameters, not comma.

Edited by Sensei
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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.