If + And ....

  • Thread starter Thread starter l.o.c.o.s
  • Start date Start date
L

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;"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!
 
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?
 
Thank you for your quick help, but what i want is to join the two
functions....creating one function!

Thanks...
 
If I understand the question, you need something like :

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

Thanks, that's it....

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