Hello! This is a pretty simple formula but I cannot seem to find out what I am doing wrong.
Field 1: Lease Term Mode is a Pick List with “Days” and “Months” as the only option.
Field 2: Total Amount (calculation containing the If(X,Y,Z)
In the screenshot image I uploaded, Field 1 shows “Months” but the Total Amount Field shows “O” and not the formula.
I hope someone in the forum can help.
Thank you!
Attachments:
You must be
logged in to view attached files.
Hi Mitz,
I think I replied to a similar question of yours via email.
In any case, it’s due to the IF() function only working to compare numeric values.
If you want to compare text values, use the IFEQUAL(A; B; C; D)
So if A = B, then return C, otherwise return D.
Hello Brendan! Thanks so much. I opted to post queries here moving forward. 😊
.
