I am trying to write a formula to add a random percentage of markup.
I have a value in one cell of a sheet that I want to add a randomly chosen percentage to from .25% to 1.75% and place the result in another linked cell of the same workbook on a different sheet.
Like
='SOURCESHEET'!K12 plus a randomly chosen percentage from .25% to 1.75% added to the original number = contents of cell on second sheet.
Can this be done ? (Random percentages ?)
Thanks
I have a value in one cell of a sheet that I want to add a randomly chosen percentage to from .25% to 1.75% and place the result in another linked cell of the same workbook on a different sheet.
Like
='SOURCESHEET'!K12 plus a randomly chosen percentage from .25% to 1.75% added to the original number = contents of cell on second sheet.
Can this be done ? (Random percentages ?)
Thanks