@ROUND

[Guest]

Hello,

Does anyone know what @ROUND is used for in excel? Someone asked me to use
@ROUND in my formulas instead of ROUND. I am not sure what the purpose of
this would be??? It looked like my numbers came out the same.

Any information would be great!

Thanks,

Steph

 

[Guest]

It's the same thing as round you can either type "=round(B2,0)" or
"@round(B2,0)" and get the same result. You'll notice that when you start
with the @ and then view the cell after completion the @ is replaced with =.
I say save the keystroke and just use =.

 

[Nick Hodge]

Steph

@ was the lotus 1-2-3 version of =. That is the indicator that what follows
is not a literal, but a function. Excel will still recognise it, but for
fear of that compatibility being deprecated, you should use =

=ROUND(number,digits)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk

 

[Guest]

Excel replaces the @ with = automatically.

 

[Guest]

Thank you Nick and JNW - this helped a lot!