<div>
Awesome... thanks for the prompt response!<br />
<br />
EEH
</div>


<div>
Another option although the question is closed<br />
<br />
=2*INT(RAND()*2)-1
</div>


<div>
<div class="content wysiwyg-content">
Experts:<br />
<br />
I need a random number function that gives me only two values: &nbsp;-1 or 1<br />
<br />
Below rand function also generates three values: -1, 0, 1 &nbsp; <br />
<br />
=RAND()*((-1)^INT(RAND()*1<wbr />0))<br />
<br />
How should this function to be modified to only get -1 and 1?<br />
<br />
EEH
</div>
</div>


Experts:

I need a random number function that gives me only two values:  -1 or 1

Below rand function also generates three values: -1, 0, 1   

=RAND()*((-1)^INT(RAND()*10))

How should this function to be modified to only get -1 and 1?

EEH

Excel -- random number... either -1 or 1

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.