| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making all the figures in one column appear as a negative
How can I make all the cells in one column appear as a negative if they
contain a formula that inserts a positive figure? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
making all the figures in one column appear as a negative
If the positive figure is in A1
=-A1 But I suspect it's more complicated than that??? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "judgejulz" wrote in message ... How can I make all the cells in one column appear as a negative if they contain a formula that inserts a positive figure? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
making all the figures in one column appear as a negative
Using copy of your data for a test.........put -1 in an unused cell, then
right-click on it COPY then highlight the cells in question and do Right-click PasteSpecial multiply.........this will append all the formulas to include *-1 Vaya con Dios, Chuck, CABGx3 "judgejulz" wrote: How can I make all the cells in one column appear as a negative if they contain a formula that inserts a positive figure? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
making all the figures in one column appear as a negative
The formula is: =IF(L4="cir",P4,0) The figure in P4 is always positive.
I've tried putting "Nick Hodge" wrote: If the positive figure is in A1 a - in the formula and it doesn't work =-A1 But I suspect it's more complicated than that??? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "judgejulz" wrote in message ... How can I make all the cells in one column appear as a negative if they contain a formula that inserts a positive figure? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
making all the figures in one column appear as a negative
Judgejulz
=IF(L4="Cir",-P4,0) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "judgejulz" wrote in message ... The formula is: =IF(L4="cir",P4,0) The figure in P4 is always positive. I've tried putting "Nick Hodge" wrote: If the positive figure is in A1 a - in the formula and it doesn't work =-A1 But I suspect it's more complicated than that??? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "judgejulz" wrote in message ... How can I make all the cells in one column appear as a negative if they contain a formula that inserts a positive figure? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a particular cell or column required | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
Linear Mode
