在比較G2欄位與H2欄位時,希望當G2欄位不等於H2欄位時,在I2欄位出現V,相等時則留白.但是當在G2與H2欄位插入一列時,此時G2與H2會變成G3與H3,則I2欄位的比較會跟著變成G3與H3的比較,而不會去比較G2與H2的欄位,此時就可以用OFFSET函數去固定讓I2永遠是比較G2與H2,不會因為插入列而變更.(當然四則運算也可以用)
=IF((OFFSET(A2,0,6,1,1)<>(OFFSET(A2,0,7,1,1))),"V","")
OFFSET的完整語法:
OFFSET(reference,rows,cols,height,width)
輸入request system zeroize,然後輸入yes.
root> request system zeroize
warning: System will be rebooted and may not boot without configuration
Erase all data, including configuration and log files? [yes,no] (no) yes
warning: ipsec-key-management subsystem not running - not needed by configuration.
warning: zeroizing fpc0
{master:0}
root> Terminated
會自動重開機,又是一台空白的設備了,希望你有備份設定擋.