CODEWITHSUNDEEP
excelexcel-formula
torbenrudgaard
torbenrudgaard

Reputation: 2541

Excel giving error when using ROUND

I type in the number 1,234.5678 in cell A1
I type in the formula =round(A1, 1)

And get this error: enter image description here

(my , and . are switched because of European/Asian standards - could that be the reason you think?)

I tried =sum(round(A1,1)) and any other variation I could think of, all give the same error.

I tried to switch , and . to American standard, and I used ROUND instead of round. Still same error

enter image description here

Upvotes: 0

Views: 500

Answers (2)

PayPal_Kartik
PayPal_Kartik

Reputation: 226

Use =ROUND(A1,2)

And make sure that columns are numbers in format.

Upvotes: 0

Solar Mike
Solar Mike

Reputation: 8375

How about:

=ROUND(A1;1)

as the comma is often swapped with a semi colon on some systems.

Upvotes: 2

Related Questions