View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gilles Desjardins
 
Posts: n/a
Default How to show negative in cell?

Just multiply it by -1. =(A1/B1)*-1

Gilles
"Brett Romero" wrote in message
...
If I divide two negative numeric cells and put the result into a
percentage cell, it will positive, even if the change is negative. For
example:

A B
1 -6249 -5810

A1/B1 = 107.56%

The change is moving from B to A. That means I should have a negative
change. How can I show that?

Thanks,
Brett