ExcelBanter - Rounding in the Same Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding in the Same Cell (https://www.excelbanter.com/excel-worksheet-functions/240788-rounding-same-cell.html)

Johnnie[_2_]

Rounding in the Same Cell

I have this formual:

=IF(D7<L7,D7,IF(D7L7,L7,0))

I would like it to round down to the nearest quarter hour as well. I can
round in an adjacent cell, but I would like to remain in the same cell. Is
this possible?

Thanks for your help.

Johnnie

Sam Wilson

Rounding in the Same Cell

=ROUNDDOWN(4*IF(D7<L7,D7,IF(D7L7,L7,0)),0)/4

"Johnnie" wrote:

I have this formual:

=IF(D7<L7,D7,IF(D7L7,L7,0))

I would like it to round down to the nearest quarter hour as well. I can
round in an adjacent cell, but I would like to remain in the same cell. Is
this possible?

Thanks for your help.

Johnnie

Johnnie[_2_]

Rounding in the Same Cell

Sam,
Thanks, it works great!!!
Johnnie

"Sam Wilson" wrote:

=ROUNDDOWN(4*IF(D7<L7,D7,IF(D7L7,L7,0)),0)/4

"Johnnie" wrote:

I have this formual:

=IF(D7<L7,D7,IF(D7L7,L7,0))

I would like it to round down to the nearest quarter hour as well. I can
round in an adjacent cell, but I would like to remain in the same cell. Is
this possible?

Thanks for your help.

Johnnie

All times are GMT +1. The time now is 01:24 AM.