want to equal a cell number in a different cell with a negativ
The following formula will display 0 if C1 is blank:
=-N(C1)
If you want to leave the cell blank then you should use the more
complex:
=IF(C1<"",-C1,"")
HTH
Kostis Vezerides
On Oct 21, 6:46*pm, gma wrote:
hey stefi
thanks...that worked, now how do i get rid of the "#value!" thats shows in
cell D1 if cell C1 has no value?
"Stefi" wrote:
Enter in D1
=-C1
Regards,
Stefi
„gma” ezt írta:
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?
|