Q: Rounding to Lower Integer

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

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

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

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

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