If + And ....

[l.o.c.o.s]

Hi!

How can i join two or more If functions?


IF(C111+D111+E111+F111+G111=B105+C105+D105+E105+F105;"Right";"Wrong")

+

IF(C111+D111+E111+F111+G111=B104+C104+D104+E104+F104;"Right";"Wrong")

+

IF.......

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

Thanks!

[Bill Kuunders]

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

Is that what you're after?

--
Greetings from New Zealand
Bill K


"l.o.c.o.s" <[email protected]> wrote in
message news:[email protected]...
>
> Hi!
>
> How can i join two or more If functions?
>
>
> IF(C111+D111+E111+F111+G111=B105+C105+D105+E105+F105;"Write";"Wrong")
>
> +
>
> IF(C111+D111+E111+F111+G111=B104+C104+D104+E104+F104;"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
>

[l.o.c.o.s]

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

Can you help me?

Thanks...

[Andrew Taylor]

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

[paul]

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:G111)=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+F105;"Write";"Wrong")
>
> +
>
> IF(C111+D111+E111+F111+G111=B104+C104+D104+E104+F104;"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
>
>

[l.o.c.o.s]

YES!!!!

Thanks, that's it....

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