Search results

Thanks! that was easier than i had though. 'IF(SUM($A17:$E17) - INT(SUM($A17:$E17)) >=0.512,(SUM($A17:$E17)-(ROUNDDOWN((SUM($A17:$E17))/128,0)*128))+0.512,SUM($A17:$E17)-(ROUNDDOWN((SUM($A17:$E17))/128,0)*128))' :)

I have a list of values such has; 12.452 115.153 18.642 How can I add 0.512 to the number only if the decimal value is greater than .512 to get; 12.452 115.153 19.154 The list is being populated using ‘SUM($A17:$E17)-(ROUNDDOWN((SUM($A17:$E17))/128,0)*128)’ so I would...