Share
Explore BrainMass

# Creating random numbers in Excel

I'm trying to build a file with Microsoft Excel that will have the following.
X Values from -17 -> 17 (Column values)
Y Value from -17 -> 17 (row values)

What I am trying to get Excel to do is to put a random number in each spot. Numbers ranging from 1 -> 1225.

I'm not in any type of computer class. I am studying to take a test that will test my ability, to find information in a chart like what I am making.

I have attatched a picture for further clarification as well as an excel file.

If anyone knows anyway to do this, or think that they can help out in anyway in building/creating or telling me how to do it. This will be very much appreciated.

#### Solution Preview

This solution involves three main steps. First we need to create all
of the rows (numbers -17 through 17). Second, we need to create all
of the columns. Third, we need to create a random number at each
cell.

Creating all of the rows is simply a matter of manually entering the
numbers from -17 ...

#### Solution Summary

This solution demonstrates how to create random numbers in Excel.

\$2.19