Assistance merging two formulas together

[JLUK74]

Hi,

For example, in cell A16 I have the following formula:

=G15/D1 (where G15 has a value and D15 contains the value I'm dividing with)

For this example, the result is 4.900, but I want to round it down to 4.

I've tried to add the "rounddown" formula to A16 but keep getting errors.

Thanks in advance

 

[dreid1011]

Perhaps this:

=ROUNDDOWN(G15/D15,0)

 

[Anfinsen]

Hi,

For example, in cell A16 I have the following formula:

=G15/D1 (where G15 has a value and D15 contains the value I'm dividing with)

For this example, the result is 4.900, but I want to round it down to 4.

I've tried to add the "rounddown" formula to A16 but keep getting errors.

Thanks in advance

You could also use

=FLOOR.MATH(G15/D15)

 

[JLUK74]

Thanks both, appreciated.

 

[dreid1011]

You're welcome, and happy to help.