Thread: Microsoft Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
R..VENKATARAMAN
 
Posts: n/a
Default Microsoft Excel

try this
select cell F82 and click edit(menu bar)-clear-all and then write your
formula


"Laura Ann Bedard" <Laura Ann wrote in
message ...

In my Excel document on Column F Line 81 I have a positive figure of
$215.06,
On Column D Line 82 I have a Negative figure of $0.70,
My formula in Column F Line 82 is "fx =F81 - D82,
My result is a Negative figure of $214.36,
Why do I have a red figure and not black? What is going on?
All the lines before where correct, in they where Red or Black.

Larry Bedard