If + And ....
 

Hi!

How can i join two or more If functions?


IF(C111+D111+E111+F111+G111=B105+C105+D105+E105+F1 05;"Write";"Wrong")

+

IF(C111+D111+E111+F111+G111=B104+C104+D104+E104+F1 04;"Write";"Wrong")

+

IF.......

I think it's with the AND function, but how does i write the two
fuctions together?

Thanks!


--
l.o.c.o.s
------------------------------------------------------------------------
l.o.c.o.s's Profile: http://www.excelforum.com/member.php...o&userid=31182
View this thread: http://www.excelforum.com/showthread...hreadid=508546

If + And ....
 

One way.............
=If(sum($C$111:$G$111)=sum(B104:F104),"right","wro ng")
extend the formula down the column and the next one will read
=If(sum($C$111:$G$111)=sum(B105:F105),"right","wro ng")

Is that what you're after?

--
Greetings from New Zealand
Bill K


"l.o.c.o.s" wrote in
message ...

Hi!

How can i join two or more If functions?


IF(C111+D111+E111+F111+G111=B105+C105+D105+E105+F1 05;"Write";"Wrong")

+

IF(C111+D111+E111+F111+G111=B104+C104+D104+E104+F1 04;"Write";"Wrong")

+

IF.......

I think it's with the AND function, but how does i write the two
fuctions together?

Thanks!


--
l.o.c.o.s
------------------------------------------------------------------------
l.o.c.o.s's Profile:
http://www.excelforum.com/member.php...o&userid=31182
View this thread: http://www.excelforum.com/showthread...hreadid=508546

If + And ....
 

Thank you for your quick help, but what i want is to join the two
functions....creating one function!

Thanks...


--
l.o.c.o.s
------------------------------------------------------------------------
l.o.c.o.s's Profile: http://www.excelforum.com/member.php...o&userid=31182
View this thread: http://www.excelforum.com/showthread...hreadid=508546

If + And ....
 

If I understand the question, you need something like :

=IF(AND(x=y,x=z),"right","wrong")



l.o.c.o.s wrote:
Thank you for your quick help, but what i want is to join the two
functions....creating one function!

Thanks...


--
l.o.c.o.s
------------------------------------------------------------------------
l.o.c.o.s's Profile: http://www.excelforum.com/member.php...o&userid=31182
View this thread: http://www.excelforum.com/showthread...hreadid=508546

If + And ....
 

it depends if you need all conditions to be true or only one to be true
=IF(AND(SUM(C111:G111)=SUM(B105:F105),SUM(C111:G11 1)=SUM(B104:F104)),"right","wrong"),if all need to be true
=IF(or(SUM(C111:G111)=SUM(B105:F105),SUM(C111:G111 )=SUM(B104:F104)),"right","wrong"),if only one test neds to be true

--
paul
remove nospam for email addy!



"l.o.c.o.s" wrote:


Hi!

How can i join two or more If functions?


IF(C111+D111+E111+F111+G111=B105+C105+D105+E105+F1 05;"Write";"Wrong")

+

IF(C111+D111+E111+F111+G111=B104+C104+D104+E104+F1 04;"Write";"Wrong")

+

IF.......

I think it's with the AND function, but how does i write the two
fuctions together?

Thanks!


--
l.o.c.o.s
------------------------------------------------------------------------
l.o.c.o.s's Profile: http://www.excelforum.com/member.php...o&userid=31182
View this thread: http://www.excelforum.com/showthread...hreadid=508546

If + And ....
 

YES!!!! :)

Thanks, that's it....

Thanks you ( Andrew Taylor, Bill Kuunders, Paul ) for your help :cool:


--
l.o.c.o.s
------------------------------------------------------------------------
l.o.c.o.s's Profile: http://www.excelforum.com/member.php...o&userid=31182
View this thread: http://www.excelforum.com/showthread...hreadid=508546