| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If + And ....
YES!!!! :) Thanks, that's it.... Thanks you ( Andrew Taylor, Bill Kuunders, Paul ) for your help  -- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
