mardi 13 juillet 2021

how to round numbers up and down depending specefic condition in excel?

i am new to excel and i want to know ho to round numbers up and down depending on the second number after the decimal point. if the third number is equla or more than 5 add 1 to the second number and remove the third number else do remove the second number only

for example : 2.961 -> 2.96 : 2.968 -> 2.97 thanks by advance

Aucun commentaire:

Enregistrer un commentaire