Forum Discussion
Solved
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...
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?
Hi Alvar25,
The formula itself appears to be good. (tested on my end)
One thing I would check is the formatting of the cell in column D. I can't "break it" by changing the formatting here but maybe you can fix it on your end by ensuring the formatting is "text".
Also, if there is no confidential data or if you can extract just that part of the spreadsheet, perhaps you could share the spreadsheet so we can help you better.