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?

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?

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?

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?

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?