Re: rounding



On Wed, 2004-04-14 at 18:09, Rohan Walsh wrote:
Hi,
I'm using gnumeric 1.2.1 on fc1.
I have a cell formatted as currency displaying no decimal places 
(displaying the whole dollar value). The value is calculated by a 
formula. Is it possible to get gnumeric to use the whole dollar value as 
input for other formulas rather than the actual value?

We always use the real value rather than the displayed value. To have
the real value match the displayed value just wrap the formula in that
cell with a round() function call.

Andreas
-- 
Andreas J. Guelzow
Taliesin Software, Shelties, Pyrsheps
and Shetland Sheep

Attachment: signature.asc
Description: This is a digitally signed message part



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]