Forum Discussion
NZWil
Dec 08, 2021Copper Contributor
Choose(randbetween) inside If statement generate error
Hello,
i am having an issue with my formula. i noticed most use if for a true false statement but i need it to calculate another function if it's false and so far it only show #NAME?
Here is my formula.
I also am not sure if i should incorporate [ ] before my false and true result.
=IF(L165=Tunai;""; CHOOSE(RANDBETWEEN(1;5); "B"; "N"; "R"; "M"; "CIMB N"))