Hi,
I am getting the attached error while inputting IF function.
The ask is to put Yes if the per person expense is greater than 50 and No if the pp expense is less than 50.
Can you please help how do I resolve this.
Thanks for your help in advance.
Hello @mihir_mir_jb , Thanks for posting your question in the community,
Please check the answer as accepted solution so that other users can benefit from it 🙂
Cheers,
Zak
Hi @mihir_mir_jb you don't need the = at the start of the formula.
Hi @mihir_mir_jb ,
try:
IF ([Per Person Expense]) <= 50 THEN'Yes'ELSE'No'ENDIF
Best,
Roland
Thank you very much @RolandSchbert, it worked.