小蘭 asked in 電腦與網際網路軟體 · 1 decade ago

EXCEL顯示計算過程?急~~

A1=2,A2=3

我輸入程式是會寫=A1+A2

顯示出來會是5

但是我想要變成2+3=5

而不是只有5

這樣我該如何列式?謝謝

Update:

請問:因為要套入公式所以會有下列的情形發生,又該如何解決?

A1=2,A2=空格,A3=3

=CONCATENATE(A1,"+",A2,"+",A3,"=",A1+A2+A3)

會變成2++3=5

該如何轉變成2+3=5

因為還要套入別的式子,所以不希望直接把A2刪掉

3 Answers

Rating
  • 小球
    Lv 6
    1 decade ago
    Favorite Answer

    輸入公式如下

    =CONCATENATE(A1,"+",A2,"=",A1+A2)

    ^.^

    2010-02-10 15:46:21 補充:

    =CONCATENATE(IF(A1>0,A1,""),IF(A1>0,"+",""),IF(A2>0,A2,""),IF(A2>0,"+",""),IF(A3>0,A3,""),"=",A1+A2+A3)

    2010-02-11 10:04:35 補充:

    =CONCATENATE(IF(A1<>0,A1,""),IF(A1<>0,"+",""),IF(A2<>0,A2,""),IF(A2<>0,"+",""),IF(A3<>0,A3,""),"=",A1+A2+A3)

    如此負數可可適用嘍~

  • 顯栓
    Lv 7
    1 decade ago

    =A1&TEXT(A2,"+0;-0;")&TEXT(A3,"+0;-0;")&"="&SUM(A1:A3)

    負數也適用.

  • 1 decade ago

    EXCEL無法像你寫的這樣顯示。

    只能直接在儲存格輸入2+3=5

Still have questions? Get your answers by asking now.