Help formula

[Thomas_Brandon]

I need to write a formula but I’m not the best so hope you can help!

I need the formula to do the following

“If the total in the cell is equal to 6.5 or greater than 6.5 then I need it to deduct 0.5”

Probably easy as but I can’t get my head round it and like I said I’m not the best :thumbs_up: thanks in advance

[#2]

@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.