**エクセル・CELL関数 [#fe951d7a] #author("2025-04-21T10:23:16+09:00","default:massy","massy") #html{{ <BODY TEXT="#000000"><TABLE FRAME=VOID CELLSPACING=0 COLS=7 RULES=NONE BORDER=0> <COLGROUP><COL WIDTH=25><COL WIDTH=28><COL WIDTH=48><COL WIDTH=29><COL WIDTH=29><COL WIDTH=138><COL WIDTH=28></COLGROUP> <TBODY> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" WIDTH=25 HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696"> </TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" WIDTH=28 ALIGN=CENTER BGCOLOR="#969696"> A </TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" WIDTH=48 ALIGN=CENTER BGCOLOR="#969696">B</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" WIDTH=29 ALIGN=CENTER BGCOLOR="#969696"> C </TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" WIDTH=29 ALIGN=CENTER BGCOLOR="#969696"> D </TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" WIDTH=138 ALIGN=CENTER BGCOLOR="#969696">E</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" WIDTH=28 ALIGN=CENTER BGCOLOR="#969696"> F </TD> </TR> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696" SDVAL="1" SDNUM="1041;">1</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696" SDVAL="2" SDNUM="1041;">2</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=RIGHT SDVAL="12345" SDNUM="1041;">12345</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=RIGHT SDVAL="2" SDNUM="1041;">2</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>←</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>=CELL("row",B2)</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696" SDVAL="3" SDNUM="1041;">3</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=RIGHT SDVAL="2" SDNUM="1041;">2</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>←</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>=CELL("col",B2)</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0" HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696" SDVAL="4" SDNUM="1041;">4</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #000000; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0" HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696" SDVAL="5" SDNUM="1041;">5</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #000000; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=RIGHT SDVAL="4" SDNUM="1041;">4</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>←</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>=CELL("row",A4:B6)</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0" HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696" SDVAL="6" SDNUM="1041;">6</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #000000; border-left: 1px solid #c0c0c0; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=RIGHT SDVAL="1" SDNUM="1041;">1</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>←</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT>=CELL("col",A4:B6)</TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" HEIGHT=19 ALIGN=CENTER BGCOLOR="#969696" SDVAL="7" SDNUM="1041;">7</TD> <TD STYLE="border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> <TD STYLE="border-top: 1px solid #c0c0c0; border-bottom: 1px solid #c0c0c0; border-left: 1px solid #c0c0c0; border-right: 1px solid #c0c0c0" ALIGN=LEFT><BR></TD> </TR> </TBODY></TABLE><!-- ************************************************************************** --></BODY></HTML> }}