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

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


"steph44haf" wrote:

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

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

HIS
www.nickhodge.co.uk

"steph44haf" wrote in message
...
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

Excel replaces the @ with = automatically.
--
JNW


"Nick Hodge" wrote:

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

HIS
www.nickhodge.co.uk

"steph44haf" wrote in message
...
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

Thank you Nick and JNW - this helped a lot!

"steph44haf" wrote:

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