I am mocking up patient fall data by age group for a sample report from an Excel dataset. What I’m trying to do is create a random value based on the cell contents from another cell. Cell D4 contains the value of 0.7% I want cell E4 to be a random value +-20% of D4. No other constraints exist.
Thank you, Doug

I did try variations of randbetween and rand but can’t sort out how to do it based on another cell value.