Excel: 2 IF functions

[Function]

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.

[John Cuthber]

is this the sort of thing you are after?

http://www.techonthenet.com/excel/formulas/if_nested.php

[Function]

is this the sort of thing you are after?

http://www.techonthenet.com/excel/formulas/if_nested.php

 

Works perfectly! Thanks, John!

[fiveworlds]

You can also directly copy and paste tables from html.

[John Cuthber]

You can also directly copy and paste tables from html.

And some cut flowers last longer if you put a little sugar in the water in the vase.

[fiveworlds]

And some cut flowers last longer if you put a little sugar in the water in the vase.

 

But what does that have to do with using if statements for tabular data?

[davidivad]

why not just use something else.

you can write your own formulas?

Edited November 10, 2014 by davidivad

[John Cuthber]

But what does that have to do with using if statements for tabular data?

Not much.

What has HTML table handling got to do with nested if functions in Excel?

[fiveworlds]

Not much.

What has HTML table handling got to do with nested if functions in Excel?

 

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

[Greg H.]

And some cut flowers last longer if you put a little sugar in the water in the vase.

 

I see what you did there.

[Function]

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 November 10, 2014 by Function

[John Cuthber]

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

And, since he's not copy + pasting anything, that is about as relevant as my tip on keeping flowers looking fresh.

[Function]

And, since he's not copy + pasting anything, that is about as relevant as my tip on keeping flowers looking fresh.

 

Touché, master Cuthber.

[Strange]

 

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

 

 

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

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

 

Please stop posting irrelevant nonsense.

[John Cuthber]

 

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

 

Please stop posting irrelevant nonsense.

Things like that were the reason I started using VBA to process stuff in Excel.

[Function]

 

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

[Sensei]

 

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 November 10, 2014 by Sensei