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
copying a cell that has been formatted to cell with conditionals 1
Formula - If Statement with blank 3
A staying on schedule formula: 2
How can I nest more than seven functions in MS Excel? 3
Warning when in another cell after entering a formula. 2
IF OR AND in same conditional formula 2
Please help with SumIf 2

Top