Forum Discussion

Alvar25's avatar
Alvar25
Copper Contributor
Jul 22, 2020
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...
  • SergeiBaklan's avatar
    Jul 22, 2020

    Alvar25 

    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?

Resources