ExcelBanter - How can I get a defalt of a negitive number for a cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I get a defalt of a negitive number for a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/88102-how-can-i-get-defalt-negitive-number-cell.html)

Doug

How can I get a defalt of a negitive number for a cell?

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?

Dave O

How can I get a defalt of a negitive number for a cell?

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

All times are GMT +1. The time now is 04:10 PM.