Re: [Clip] rounding in a clip
- Don Passenger wrote:
>Thanks for the quick response Lotta, I am finding an additionalI guess my first reply hasn't rolled in yet, the one about ROUND.
>problem. It appears that these math functions are only available via
>control+e and not in clips?
>so this does work ... but how do I get it to go in a clip ... if I can?
yahoogroups is slow again.
You can do the same with CEIL and FLOOR, but I think ROUND is what you're
- On Sunday, Oct 03, 2004
Don Passenger wrote regarding "rounding in a clip";
> It appears that these math functions are only available viaHi Don,
> control+e and not in clips?
> so this does work ... but how do I get it to go in a clip ... if I can?
As an experiment I tried this and it seems to work:
Of course you'll have to modify it to your specific needs.
- I did get your first post after your second. It appears that you simply
put it inside the calc. I have to say the help on these two things
(math functions and calc) aren't all that explanative. Floor does
appear to do it and by putting it in a calc, then I should be rolling.
The other answer was interesting. I never thought of it, but
subtracting .49999 would get one the same result. Seems to make sense.
> Me said:
>>I think ROUND is what you're looking for.
> Sheesh, I read sloppy. You said round DOWN. Then it's FLOOR you want.
> ^!Info ^$Calc(FLOOR(395/60))$
Well, your original question WAS overwhelming ;-)
This post (and what follows it) could be of some help:
Larry Thomas dug into calculations with NoteTab a while back. He
For your specific situation you could look into MOD maybe, it gives
you the remainder: 395 MOD 60 = 35... I really cannot help you with
the specific use of all the functions.
- Don Passenger wrote:
> I wrote a week or two ago seeking a solution to a problem I had. TheDon,
> list has always been most helpful, but for some reason this time I got
> zero responses, so perhaps I asked the wrong way. So I guess I will try
> something simpler and then piece it together.
> If say I take the number 395, I want to divide it by 60 ... and I get
> I want to round this down to 6 (ie toss the remainder).
> Is there a math function to do this?
> I suppose if I made it a string I could toss everything including and
> after the period.
I recall you saying you always want to round down to a whole number.
The following 2 operators appear to always give the same result by