This is my function =if(A1=1,"+",if(A1=2,"-")), this function would be in cell B2. Now the problem is if A1 is neither 1 or 2 then FALSE appears in cell B2. so how do i fix it so that FALSE won't appear in cell B2 if neither 1 or 2 is in cell A1.
Also in that same function I would like to add another option, for example: if A1=3 then i would like Excel to randomly choose between either the + or - sign to appear in cell B2. I've been stuck on this for awhile and any help would be appreciated!
Also in that same function I would like to add another option, for example: if A1=3 then i would like Excel to randomly choose between either the + or - sign to appear in cell B2. I've been stuck on this for awhile and any help would be appreciated!