Hi Govind ,
There is no reason to use this ; this is used when the start and / or the endpoints ( 1 and 361 in this case ) are dynamic or cell references. In this case , all we want to do is generate an array of values for all angles between 0 and 360 ( 360 is the same as 0 ) in increments of 1.
The construct :
=ROW(1:361) - 1
will do this. We cannot directly specify 0 through 360 , because the usage ROW(0) will generate an error , which is why we use ROW(1:361) and then subtract 1 from this.
To make it more clear that we do not wish the parameters to vary , we should use :
=ROW($1:$361) - 1
which will generate the array :
{0;1;2;3;4;5;6;7;8;9;10;.....;350;351;352;353;354;355;356;357;358;359;360}
Wrapping the RADIANS function around this will convert the angle in degrees to the angle in radians.
Hence the overall formula can certainly become :
=RADIANS(ROW($1:$361) - 1)
Note that in this case using the $ sign does not prevent Excel from changing this to :
=RADIANS(ROW($1:$362) - 1)
if you insert rows between row #1 and row #361.
Using the formula Hui has used will prevent this problem.
Even if rows are inserted , the formula will not change , and the array will remain between 0 and 360.
Narayan