Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need the following working UDF modified 2 ways
Function ROll2D6() ROll2D6 = Application.RoundUp(Rnd() * 6, 0) + Application.RoundUp(Rnd() * 6, 0) End Function Way 1: accept 2 integer inputs int1 will tell the number of instances of Application.RoundUp(Rnd() * 6, 0) to sum int2 will replace the 6 in Application.RoundUp(Rnd() * 6, 0) an exit check for if my.cell ISNUMBER()=TRUE Way 2: accept 2 integer inputs int1 will tell the number of instances of Application.RoundUp(Rnd() * 6, 0) to sum int2 will replace the 6 in Application.RoundUp(Rnd() * 6, 0) an exit check if the cell to the right ="fail" thanks |