Rounding values

Round Down & Convert to 10’s
=ROUNDDOWN(C3,0)     Round down to no decimal places
=ROUNDDOWN(C3,1)     Round down to 1 decimal place
=ROUNDDOWN(C3,-1)    If result was 1234 this would give 1230

Convert To Hex

=DEC2HEX(A11, 4)

(Value, Digits)

Convert To Binary

Dec2Bin
Bin2Dec

Comments

Your email address will not be published. Required fields are marked *