Forum Discussion
Alvar25
Jul 22, 2020Copper Contributor
IF Statement with RANDBETWEEN
Hello. I am having issues with my IF statement. I would like my statement to execute a random number between 40 and 220 if the cell I'm referencing is Yes. Otherwise I would like it to be 0. Currentl...
- Jul 22, 2020
That's something else, in general formula shall work
As variant in column D word Yes is with extra space or non-printable character. Does simple =D5="Yes" return TRUE?
SergeiBaklan
Jul 22, 2020Diamond Contributor
That's something else, in general formula shall work
As variant in column D word Yes is with extra space or non-printable character. Does simple =D5="Yes" return TRUE?
- Alvar25Jul 22, 2020Copper Contributor
SergeiBaklan Thank you for your help! D5 ended up returning as FALSE when I imported to a new Workbook. It works now after deleting and pasting my data again. Thank you again!
- SergeiBaklanJul 24, 2020Diamond Contributor
Alvar25 , you are welcome, glad to help