MattLevand
New Member
- Joined
- May 22, 2021
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
I'm generating a random number in Cell AI5 between 2.5 and 6.0 if data is entered in Cell X5 using the formula =IF(X5>1,2.5+3.5*RAND(),""). Then i drag this down a spread sheet 365 cells for the entire year. Instead of changing the cell to a string everytime it generates a number (to keep the number from changing) couldn't i call a macro that generates my random number only if data is entered in Cell X5? (Cell X5 is always a whole number if it is entered) Or is there any other better way...
Thanks,
Matt
Thanks,
Matt