Thread: Rounding issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kimo Kimo is offline
external usenet poster
 
Posts: 25
Default Rounding issue

Help....;o)
I have this formula : =IF(K10=1,I10*K10,K10-I10) and it keeps coming up
with looks like some type of rounding. I have no condition formats set in
these cells nor anything else, they are just formulas. Maybe someone knows
of a better formula I can use. The thing is I have to have to make sure that
the "total" column stays at zero dollars so that my sum function works at the
end of the column. Thanks in advance.

I K L
UNIT PRICE QUANTITY * TOTAL**
$10.00 -6 -$16.00

GRAND TOTALS: -$16.00