close

I am trying to design a Excel Workbook that only needs the number 1 in any
given cell however, some cells require a negitive 1 to complete the task. How
can I setup individual cells to receive an input of 1 but have Excel receive
it as a negitive 1?

My best guess: enter 1 in a given cell, and set an output cell formula
to =0-input cell

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()