Browse Groups

• I didn t see this part. ... I don t know Excel, but I have a hunch that CEIL and FLOOR correspond to roundup() and rounddown()... Lotta
Message 1 of 11 , Oct 3, 2004
View Source
I didn't see this part.

>I also find a ROUND function in math help, but again no explaination of
>how it works. How might this compare to the rounddown() function in
>excel for example? That program offers roundup(), rounddown() and round().

I don't know Excel, but I have a hunch that CEIL and FLOOR correspond to
roundup() and rounddown()...

Lotta
• Thanks for the quick response Lotta, I am finding an additional problem. It appears that these math functions are only available via control+e and not in
Message 2 of 11 , Oct 3, 2004
View Source
Thanks for the quick response Lotta, I am finding an additional
problem. It appears that these math functions are only available via
control+e and not in clips?

floor(395/60)=6
so this does work ... but how do I get it to go in a clip ... if I can?

loro wrote:

> I didn't see this part.
>
>
>>I also find a ROUND function in math help, but again no explaination of
>>how it works. How might this compare to the rounddown() function in
>>excel for example? That program offers roundup(), rounddown() and round().
>
>
> I don't know Excel, but I have a hunch that CEIL and FLOOR correspond to
> roundup() and rounddown()...
>
> Lotta
>
>
>
>
>
>
>
>
>
>
>
>
>
• Don, If you subtract .5 from the number first (possibly .4999) it would be the same as rounding down. Test ^!set %x%=^\$Calc(395/60-.49999;0)\$ ^!Info
Message 3 of 11 , Oct 3, 2004
View Source
Don,
If you subtract .5 from the number first (possibly .4999) it would be the
same as rounding down.

Test
^!set %x%=^\$Calc(395/60-.49999;0)\$
^!Info ^395/60=^%x%
^!set %x%=^\$Calc(360/60-.49999;0)\$
^!Info 360/60=^%x%
^!set %x%=^\$Calc(359.999/60-.49999;0)\$
^!Info 359.999/60=^%x%
Warner

----- Original Message -----
From: "Don Passenger" <dpasseng@...>
To: <ntb-clips@yahoogroups.com>
Sent: Sunday, October 03, 2004 1:18 PM
Subject: Re: [Clip] rounding in a clip

>
> Thanks for the quick response Lotta, I am finding an additional
> problem. It appears that these math functions are only available via
> control+e and not in clips?
>
> floor(395/60)=6
> so this does work ... but how do I get it to go in a clip ... if I can?
>
> loro wrote:
>
>> I didn't see this part.
>>
>>
>>>I also find a ROUND function in math help, but again no explaination of
>>>how it works. How might this compare to the rounddown() function in
>>>excel for example? That program offers roundup(), rounddown() and
>>>round().
>>
>>
>> I don't know Excel, but I have a hunch that CEIL and FLOOR correspond to
>> roundup() and rounddown()...
>>
>> Lotta
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>
>
>
>
>
>
Don,
If you subtract .5 from the number first (possibly .4999) it would be the
same as rounding down.

Test
^!set %x%=^\$Calc(395/60-.49999;0)\$
^!Info ^395/60=^%x%
^!set %x%=^\$Calc(360/60-.49999;0)\$
^!Info 360/60=^%x%
^!set %x%=^\$Calc(359.999/60-.49999;0)\$
^!Info 359.999/60=^%x%
Warner

----- Original Message -----
From: "Don Passenger" <dpasseng@...>
To: <ntb-clips@yahoogroups.com>
Sent: Sunday, October 03, 2004 1:18 PM
Subject: Re: [Clip] rounding in a clip

>
> Thanks for the quick response Lotta, I am finding an additional
> problem. It appears that these math functions are only available via
> control+e and not in clips?
>
> floor(395/60)=6
> so this does work ... but how do I get it to go in a clip ... if I can?
>
> loro wrote:
>
>> I didn't see this part.
>>
>>
>>>I also find a ROUND function in math help, but again no explaination of
>>>how it works. How might this compare to the rounddown() function in
>>>excel for example? That program offers roundup(), rounddown() and
>>>round().
>>
>>
>> I don't know Excel, but I have a hunch that CEIL and FLOOR correspond to
>> roundup() and rounddown()...
>>
>> Lotta
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>
>
>
>
>
>
• ... I guess my first reply hasn t rolled in yet, the one about ROUND. yahoogroups is slow again. ^!Info ^\$Calc(ROUND(395/60))\$ You can do the same with CEIL
Message 4 of 11 , Oct 3, 2004
View Source
Don Passenger wrote:
>Thanks for the quick response Lotta, I am finding an additional
>problem. It appears that these math functions are only available via
>control+e and not in clips?
>
>floor(395/60)=6
>so this does work ... but how do I get it to go in a clip ... if I can?

I guess my first reply hasn't rolled in yet, the one about ROUND.
yahoogroups is slow again.

^!Info ^\$Calc(ROUND(395/60))\$

You can do the same with CEIL and FLOOR, but I think ROUND is what you're
looking for.

Lotta
• ... Sheesh, I read sloppy. You said round DOWN. Then it s FLOOR you want. ^!Info ^\$Calc(FLOOR(395/60))\$ Lotta
Message 5 of 11 , Oct 3, 2004
View Source
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))\$

Lotta
• On Sunday, Oct 03, 2004 Don Passenger wrote regarding rounding in a clip ; ... Hi Don, As an experiment I tried this and it seems to work: ^!Set
Message 6 of 11 , Oct 3, 2004
View Source
On Sunday, Oct 03, 2004
Don Passenger wrote regarding "rounding in a clip";

> It appears that these math functions are only available via
> control+e and not in clips?
>
> floor(395/60)=6
> so this does work ... but how do I get it to go in a clip ... if I can?

Hi Don,

As an experiment I tried this and it seems to work:

^!Set %value%=^\$CALC(FLOOR(395/60))\$
^%value%

Of course you'll have to modify it to your specific needs.

HTH
Ben
• 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
Message 7 of 11 , Oct 3, 2004
View Source
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.

loro wrote:

> 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))\$
>
> Lotta
• Don, Well, your original question WAS overwhelming ;-) This post (and what follows it) could be of some help:
Message 8 of 11 , Oct 3, 2004
View Source
Don,

Well, your original question WAS overwhelming ;-)

This post (and what follows it) could be of some help:

http://groups.yahoo.com/group/ntb-clips/message/10156

Larry Thomas dug into calculations with NoteTab a while back. He
lives on...

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.

Hugo
• ... Don, 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 rounding down.
Message 9 of 11 , Oct 4, 2004
View Source
Don Passenger wrote:
> I wrote a week or two ago seeking a solution to a problem I had. The
> 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
> 6.58333333
> 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.

Don,

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
rounding down.

^\$Calc(FLOOR(395/60))\$
^\$Calc(INT(395/60);0)\$

hrs
Your message has been successfully submitted and would be delivered to recipients shortly.
• Changes have not been saved
Press OK to abandon changes or Cancel to continue editing
• Your browser is not supported
Kindly note that Groups does not support 7.0 or earlier versions of Internet Explorer. We recommend upgrading to the latest Internet Explorer, Google Chrome, or Firefox. If you are using IE 9 or later, make sure you turn off Compatibility View.