@ROUND

S

steph44haf

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
 
J

JNW

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 =.
 
N

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

[email protected]
www.nickhodge.co.uk
 
Top