Dinny ken how to PM you so just putting it down here. I'm building a spreadsheet and 1 of the columns I need to change the value of the number. The columns are ( T ) & ( U ) The formula I am trying to put in is =if(t5<=500,0,if(t5<=365,1,if(t5<=84,2,if(t5<=56,3,if(tf5<=42,4,))))) etc. CHEERS