Hola Renzo Si yo lo entiendo correctamente (ve abajo) entonces esto debe ayudar:
=If(ISERROR(Su Fórmula),0,Su Fórmula)
Tenga un día agradable<CENTER><TABLE ALIGN=CENTER BORDER=1><TR><TD BGCOLOR=#0C266B COLSPAN=5><FONT COLOR=WHITE>
Microsoft Excel - Book1_______________Running: xl2000 : OS = Windows (32-bit) 4.10</FONT></TD></TR><TR><TD BGCOLOR=#D4D0C8 COLSPAN=5>(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp</TD></TR><TR><TD ALIGN=CENTER COLSPAN=2 BGCOLOR=White>D2</TD><TD ALIGN=CENTER BGCOLOR=#D4D0C8 >
=</TD><TD COLSPAN=2 BGCOLOR=White> =MATCH(C2,A2:A10,0)</TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER> </TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>
A</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>
B</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>
C</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>
D</TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
2</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test1</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>3</FONT></TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#0000FF>Test10</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000> =MATCH(C2,A2:A10,0)</FONT></TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
3</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test2</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>0</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000> =IF(ISERROR(MATCH(C2,A2:A10,0)),0,MATCH(C2,A2:A10,0))</FONT></TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
4</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test3</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>6</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF> </TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
5</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test4</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>1</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF> </TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
6</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test5</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>12</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF> </TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
7</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test6</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>6</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF> </TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
8</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test7</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>6</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF> </TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
9</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test8</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>15</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF> </TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>
10</TD><TD BGCOLOR=#FFFF99 ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#FF0000>Test9</FONT></TD><TD BGCOLOR=#FFFFFF ALIGN=Center VALIGN=BOTTOM ><FONT FACE=Arial COLOR=#000000>1.5</FONT></TD><TD BGCOLOR=#FFFFFF> </TD><TD BGCOLOR=#FFFFFF> </TD></TR><TR><TD COLSPAN=5><U>Sheet1</U></TD></TR></TABLE><FONT COLOR=#339966>To see the formula in the cells just click on the cells hyperlink</FONT><FONT COLOR=#339966 SIZE=1>The above image was automatically generated by [HtmlMaker V1.23]</FONT><FONT COLOR=#339966 SIZE=1>If you want this code,<A HREF=mailto:corosuke@chan.co.jp>click here</A> and Colo will email the file to you.</FONT><FONT COLOR=#339966 SIZE=1>This code was graciously allowed to be modified: by<A HREF=mailto:ivanmoala@xtra.co.nz>Ivan F Moala</A> All credit to Colo</FONT></CENTER>
_________________
Kind Regards,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font><MARQUEE>Have a Nice day
</MARQUEE>
This message was edited by Ivan F Moala on 2002-05-16 15:38