Hi All,
I'm having a round down issue and I keep getting errors.
The following are just examples, the L17 is the cell with a value which needs to be rounded down.
If L17 = 5.94 Then M17 needs to round down to 5.93
If L17 = 5.91 Then M17 needs to round down to 5.87
If L17 = 5.67 Then M17 needs to remain the same as it ends in a 7
If L17 = 5.63 Then M17 needs to remain the same as it ends in a 3
Any help would be greatly appreciated.
Cheers
Bookmarks