Thread: want to equal a cell number in a different cell with a negative si
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
panther42 panther42 is offline
external usenet poster
  
Posts: 2
Default want to equal a cell number in a different cell with a negative si
I know this is a really bad work around, but how about :

(In D1) = (C1-C1-C1)

Kev

"gma" wrote:

Problem:
Say I have a number in cell C1 and I want that number in cell D1 but with a
- sign in front of it exp: 20% in cell C1 in D1 I want -20%. CAn anyone help
me with this?
Reply With QuoteReply With Quote