| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| select cell based on a number in another cell | New Users to Excel | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Hybrid Mode
