Hello, please dont be too harsh with me I am starting with this and have a simple question I cannot solve by myself though trying different combinations of formulas.
I have 3 fields : possibleloan1, possibleloan2, loanoutput. I want a formula that defines loanoutput. Loanoutput is possibleloan1 if possibleloan1 is greater or equal possibleloan1. if possibleloan1 is minor possibleloan2 , loanoutput should be possibleloan2.
I tried for loanoutput:
IF(possibleloan1 > possibleloan2, TRUE(possibleloan1), FALSE(possibleloan2))
Do you know what I did wrong?
Airtable is not accepting the formula itself though I wrote it in accordance to the guidelines.
Thanks in advance!