日常的excel函数公式有哪些？

姹傚拰=SUM(鏁板瓧锛屾暟瀛? 銆佹眰骞冲潎鍊?AVERAGE(number1,number2,鈥︹€?銆佹眰鏈€澶у€?MAX(number1,number2鈥︹€?銆佹眰鏈€灏忓€?MIN(number1,number2鈥︹€?銆佹眰鎺掑悕=RANK锛圢umber,ref,order锛夈€両F澶氭潯浠跺垽鏂繑鍥炲€煎叕寮忥細C2=IF(AND(A2<500,B2="鏈埌鏈?quot;),"琛ユ","")璁℃暟=COUNTIF锛堟潯浠惰寖鍥达紝鏉′欢锛夈€?/p>

SUM鍑芥暟锛屼富瑕佸姛鑳斤細姹傚嚭鎵€鏈夊弬鏁扮殑绠楁湳鎬诲€笺€備娇鐢ㄦ牸寮忥細SUM(number1,number2,鈥︹€?锛屽弬鏁拌鏄庯細number1,number2....锛氶渶瑕佹眰鎬诲€肩殑鏁板€兼垨寮曠敤鍗曞厓鏍硷紙鍖哄煙锛夛紝鍙傛暟涓嶈秴杩?0涓€?/p>

AVERAGE鍑芥暟锛屽嚱鏁板悕绉帮細AVERAGE锛屼富瑕佸姛鑳斤細姹傚嚭鎵€鏈夊弬鏁扮殑绠楁湳骞冲潎鍊笺€?浣跨敤鏍煎紡锛欰VERAGE(number1,number2,鈥︹€? 鍙傛暟璇存槑锛歯umber1,number2,鈥︹€︼細闇€瑕佹眰骞冲潎鍊肩殑鏁板€兼垨寮曠敤鍗曞厓鏍硷紙鍖哄煙锛夛紝鍙傛暟涓嶈秴杩?0涓€偮?/p>

MAX鍑芥暟锛屽嚱鏁板悕绉帮細MAX锛屼富瑕佸姛鑳斤細姹傚嚭涓€缁勬暟涓殑鏈€澶у€笺€備娇鐢ㄦ牸寮忥細MAX(number1,number2鈥︹€?锛屽弬鏁拌鏄庯細number1,number2鈥︹€︿唬琛ㄩ渶瑕佹眰鏈€澶у€肩殑鏁板€兼垨寮曠敤鍗曞厓鏍硷紙鍖哄煙锛夛紝鍙傛暟涓嶈秴杩?0涓€?/p>

MIN鍑芥暟锛屽嚱鏁板悕绉帮細MIN锛屼富瑕佸姛鑳斤細姹傚嚭涓€缁勬暟涓殑鏈€灏忓€笺€備娇鐢ㄦ牸寮忥細MIN(number1,number2鈥︹€?锛屽弬鏁拌鏄庯細number1,number2鈥︹€︿唬琛ㄩ渶瑕佹眰鏈€灏忓€肩殑鏁板€兼垨寮曠敤鍗曞厓鏍硷紙鍖哄煙锛夛紝鍙傛暟涓嶈秴杩?0涓€?/p>

鍑芥暟鍚嶇О锛歊ANK锛屼富瑕佸姛鑳斤細杩斿洖鏌愪竴鏁板€煎湪涓€鍒楁暟鍊间腑鐨勭浉瀵逛簬鍏朵粬鏁板€肩殑鎺掍綅銆備娇鐢ㄦ牸寮忥細RANK锛圢umber,ref,order锛夛紝鍙傛暟璇存槑锛歂umber浠ｈ〃闇€瑕佹帓搴忕殑鏁板€硷紱ref浠ｈ〃鎺掑簭鏁板€兼墍澶勭殑鍗曞厓鏍煎尯鍩燂紱order浠ｈ〃鎺掑簭鏂瑰紡鍙傛暟锛堝鏋滀负鈥?鈥濇垨鑰呭拷鐣ワ紝鍒欐寜闄嶅簭鎺掑悕锛屽嵆鏁板€艰秺澶э紝鎺掑悕缁撴灉鏁板€艰秺灏忥紱濡傛灉涓洪潪鈥?鈥濆€硷紝鍒欐寜鍗囧簭鎺掑悕锛屽嵆鏁板€艰秺澶э紝鎺掑悕缁撴灉鏁板€艰秺澶э紱锛?/p>