Forum Discussion
Problem with if function
Hi, hope you can help and I'm sure it is a simple issue. I'm using "IF" function for the first time and I have attached a screenshot of the data that I'm using. This is just practice data that I ...
Hi Luke,
RANDBETWEEN generates new sets of numbers every time you edit any cell in the sheet. To avoid that you may generate your numbers, after that copy and paste them as values on the same place.
By the way, your formula could be
=E2*(1.6*(G2>800)+F2)
- Hi,
Thank you so much for your quick, responsive reply. Wasn’t aware that RANDBETWEEN would repeatedly generate random numbers.
Will try that and thank you for the alternative formula! Still getting used to excel.
Kind regards,
Luke
