Rounding in the Same Cell

J

Johnnie

I have this formual:

=IF(D7<L7,D7,IF(D7>L7,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When there is a tie for "MAX" values... 6
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Change the colour of a neighbouring cell 6
rounding a number up to a certain ending digit 6
copying a cell that has been formatted to cell with conditionals 3
Returning next item in list 1
Formula - If Statement with blank 4
Warning when in another cell after entering a formula. 2

Top