Dec 07 2021 04:36 PM
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"))
Dec 07 2021 05:05 PM
@NZWilTunai pakai kutip ya..