fix random values

shrikant sinnur

New Member
Joined
Jan 29, 2009
Messages
16
help me,

if i have a value in A1 cell, want to add random value to A1 in B1 cell(B1=A1+rand()*8) but whenever i click other cell or open the file B1 value changes eventho A1 value is fixed.

is there any way to do,when i changes A1 value then only B1 value should change.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
If you create you own random function without setting VOLATILE to true then you have a non-volatile random function.
Code:
Function fnNonVolRand() As Double
    Let fnNonVolRand = Rnd(Now)
End Function
You could also set calculation to MANUAL, but that might throw off any users (including yourself) because you would need to hit the F9 key to have ANY of the cells calculate.
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top