TrimPath Forum


About TrimPath stuff, like Junction, Next Action, JavaScript Templates, TrimQuery, TrimSpreadsheet, etc...

You are not logged in.

  • Index
  •  » Num Sum
  •  » Slight confusion : how to use the fixed function

#1 2005-12-28 06:00:38

austinuu
New member
Registered: 2005-12-24
Posts: 1

Slight confusion : how to use the fixed function

I can't get the fixed function to work -- it keeps returning an error message about an invalid value.

The spreadsheet that I am working on is http://www.numsum.com/spreadsheet/show/7385 -- I'd like to truncate the calculated values to the nearest whole number.

Any suggestions?

Offline

 

#2 2005-12-31 02:16:40

steve.yen
Chef
From: Silicon Valley
Registered: 2005-07-10
Posts: 252
Website

Re: Slight confusion : how to use the fixed function

Don't forget to use uppercase FIXED instead of a lowercase 'fixed'.  (Yeah, it's a bug.)

Offline

 
  • Index
  •  » Num Sum
  •  » Slight confusion : how to use the fixed function

Board footer

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson