=IF(A10,-A1,A1)

--
HTH

Bob Phillips

"Gav" wrote in message
...
Does any one know the formula for converting positive figures to Negatives