[MarkV]

I have created a virtual business project on a xcell sheet and require some
help on how to mimic values rolled from 2 dies.
ie. manually casting two real game dies and both the values are random.
I want the above to reflect on a sheet upon pressing a button.

Can anyone help?

[Bob Phillips]

=RANDBETWEEN(1,6)+RANDBETWEEN(1,6)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Markv" wrote in message
...
I have created a virtual business project on a xcell sheet and require some
help on how to mimic values rolled from 2 dies.
ie. manually casting two real game dies and both the values are random.
I want the above to reflect on a sheet upon pressing a button.

Can anyone help?

[Mike H]

Hi,

Put this in 2 cells

=RANDBETWEEN(1,6)

Tap F9 to roll the dice again

Mike

"Markv" wrote:

I have created a virtual business project on a xcell sheet and require some
help on how to mimic values rolled from 2 dies.
ie. manually casting two real game dies and both the values are random.
I want the above to reflect on a sheet upon pressing a button.

Can anyone help?

[MarkV]

Thanks Mike, Bob It works, can this work with a button in the sheet ie.
"Press to Roll"?
If so can you assist.

"Mike H" wrote:

Hi,

Put this in 2 cells

=RANDBETWEEN(1,6)

Tap F9 to roll the dice again

Mike

"Markv" wrote:

I have created a virtual business project on a xcell sheet and require some
help on how to mimic values rolled from 2 dies.
ie. manually casting two real game dies and both the values are random.
I want the above to reflect on a sheet upon pressing a button.

Can anyone help?

[Bob Phillips]

Just drag a button from the forms toolbar and assign a simple macro

Sub Recalc
Activesheet.Calculate
End Sub

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Markv" wrote in message
...
Thanks Mike, Bob It works, can this work with a button in the sheet ie.
"Press to Roll"?
If so can you assist.

"Mike H" wrote:

Hi,

Put this in 2 cells

=RANDBETWEEN(1,6)

Tap F9 to roll the dice again

Mike

"Markv" wrote:

I have created a virtual business project on a xcell sheet and require
some
help on how to mimic values rolled from 2 dies.
ie. manually casting two real game dies and both the values are random.
I want the above to reflect on a sheet upon pressing a button.

Can anyone help?

[MarkV]

Thanks Bob

"Bob Phillips" wrote:

Just drag a button from the forms toolbar and assign a simple macro

Sub Recalc
Activesheet.Calculate
End Sub

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Markv" wrote in message
...
Thanks Mike, Bob It works, can this work with a button in the sheet ie.
"Press to Roll"?
If so can you assist.

"Mike H" wrote:

Hi,

Put this in 2 cells

=RANDBETWEEN(1,6)

Tap F9 to roll the dice again

Mike

"Markv" wrote:

I have created a virtual business project on a xcell sheet and require
some
help on how to mimic values rolled from 2 dies.
ie. manually casting two real game dies and both the values are random.
I want the above to reflect on a sheet upon pressing a button.

Can anyone help?