Choose(randbetween) inside If statement generate error

Occasional Visitor


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"))

1 Reply

@NZWilTunai pakai kutip ya..