| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making # + or - based on another cells contents
how do I make one cell postive or negative based on another cells contents.
For Example: 123.00 c 565.00 d 613.00 d When I upload all numbers come up postive like shown above. How do I get it so the 123.00/"c" row come up negative. I want all "c"/credits to come up as a negative number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a value based on contents of two cells | Excel Worksheet Functions | |||
| How do I add a cell based on another cells contents? | Excel Discussion (Misc queries) | |||
| Counting based on other cells contents... | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Threaded Mode
