Is there a function in numbers to round down to the next lower integer?
ex:
you multiply an odd number times .50, say 7 x .50 and it returns 3.50 and you always want it rounded down to the next lower integer, in this case 3
iMac, OS X Mavericks (10.9)
Hi, I think you're looking for ROUNDDOWN.
If 0.50 is in A2 and 7 in B2 you would use:
=ROUNDDOWN(A2×B2,0)
The 0 means zero digits after the decimal point.
SG
If D2 contains 2.85
and
C2=FLOOR(D2,1)
then C2 will show "2"
DT,
As SG notes, the only ROUND function that will do as you ask is ROUNDDOWN. That's because the example you gave wouldn't be the actual result of ROUND(value, digits) with digits = 0. 7.5 would become 8.
TRUNC would give you want you are demonstrating too.
Jerry
Here are my cells and numbers, what do you reccomend?
BK24=.50
BH=7
I want BH26 to display 3.00
BH does not appear to be a valid cell reference.
I want BH26 to display 3.00
Do you mean you want it to display 3.00 but still keep the actual unrounded value?
Don't the proposed ROUNDDOWN, FLOOR, TRUNC do what you want?
SG
That shoud have been BH25. Here is the result of SGIII's suggestion
Hi, it looks as if you've got an extra ( and ) after ROUNDDOWN in your formula. Remove those and see if it does what you want.
SG
Have it now, thanks
Would you happen to be fluent in Applescript?
Would you happen to be fluent in Applescript?
"Fluent" is a relative word! I know enough to make it do some useful things. Others here can make it sing!
If you have an AppleScript issue related to this thread, pose the question here and we can all try to help.
If it's not related to this thread, maybe you could start a new question.
SG
Iwill start a new thread, thanks for the help. I am managing to work around a bit in Numbers but have no knowledge in Applescript. I had worked previously in XL but nothinbg to no with VBA. I posted my issue/question on an XL forum and got feedback along with a routine. I would need a person that could relate the VBA code to Applescript.
Ok. In case you're not aware, the old Numbers 2.3 had modest support for AppleScript, enough to be suprisingly useful. Numbers 3.0 is limited to so-called GUI-scripting, meaning you can have AppleScript access the menu and clipboard. Useful things are possible with that, but nothing like VBA. Yet. Apple released a support document indicating that AppleScript support will be coming to Numbers 3.
SG
Rounding to Lower Integer
