excelÅúÁ¿¼Ó·¨¹«Ê½

ʱ¼ä£º2013.09.06 ·¢²¼ÈË£ºÂÒÁ˽Ú×à89113

excelÅúÁ¿¼Ó·¨¹«Ê½

Òѽâ¾öÎÊÌâ

¹È¸èÂÒÁ˽Ú×à89113Óû§ÔÚ2013.09.06Ìá½»Á˹ØÓÚ¡°Ë¹¿Â´ïexcelÅúÁ¿¼Ó·¨¹«Ê½¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-10-25T10:25:46¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Ã»ÓÐʲô»ªÀöµÄÓïÑÔ,µ«ÊÇÎÒ¶ÔÄãµÄ¸Ðл²»»á¼õÉÙ £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºjt00651  

K2=h**2+I2+J2ÏÂÀ­¸´Öƹ«Ê½
l2=d2*k2ÏÂÀ­¸´Öƹ«Ê½

²»¹ý¼øÓÚÄãµÄÊýÖ¼ÊÇÎı¾Ð͵ÄÊýÖµ,ÐÞ¸ÄϹ«Ê½,²¢ÇÒΪÁËÃÀ¹Û,Ð޸Ĺ«Ê½:
=IF(AND(h**2<>"",I2<>"",J2<>""),--h**2--I2--J2,"")
=IF(D2="","",--D2*--K2)
ÒÆ¶¯¹â±êµ½K2I2µÄÓÒϽÇ,µÈ±ä³ÉºÚɫʮ×ּܵÄʱºòÏÂÀ­µ½ÄãÏ뼫֧ԪѪÒ**¤ÒªÎ»ÖÃ!