View Single Post
 
Old 10-26-2013, 11:43 PM
Kevin@Radstock Kevin@Radstock is offline Windows 7 32bit Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Perhaps something along these lines:

=IF(cell_ref>6,cell_ref-0.5,cell_ref)
Reply With Quote