- ©«¤l
- 133
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 198
- ÂI¦W
- 100
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-21
- ³Ì«áµn¿ý
- 2024-4-19
|
¦^´_ 4# shan0948
³o¤½¦¡§Ú¥Î¦b 2007 ¥H«áªºª©¥»¥i¥H¥¿±`¨Ï¥Î¡A¦ý§Ú¦b 2003 ª©¥»¤W¤]·|¨Ï¥Î¡A´N·|¥X²{ #NAME¡Hªº±¡ªp¡A«e¤GÓ IF ªº±ø¥ó¨S°ÝÃD¡A³Ì«á¤@Ó IF ¥i¯à¦b 2003 ª©¦³°ÝÃD¡A§Ú¥Î§Oªº¤½¦¡ ( ¦p«á¦C¤G¤½¦¡ ) ¨ú¥N«á¡A¥i¥H¹F¨ì»Ý¨D¡AÁÙ¬O«Ü·PÁ«ü¾É¡I
=IF($B5="","",IF($B5>9999,$B5/2,IF($B5<9999,$B5,"")))
=IF($B5="","",IF($C5>9999,$B5/2,IF($B5=$C5,"",))) |
|