Sep 27 2019 05:21 PM
Sep 27 2019 06:39 PM
@Thomas_Brandon
Assuming that A10 is the cell with the Total in it, then in a blank cell of your choice, try this...
=IF(A10>=6.5,A10-0.5,A10)
Just replace A10 with the reference of the actual cell which contains Total.