I would like to restrict decimal entries in a spreadsheet to be whole or half. For example 5.5, 7.5, 9.5, 22.5 is ok, but 5.1, 7.7, 9.4 ,22.6 etc. is not.
Is that possible with formula? The ranges of cells would be D4:D81,F4:F81, I4:I81, L4:L81