Forum Discussion
miro-subasic
Nov 26, 2022Copper Contributor
help with IF formula
Dear community, can somebody help me the following issue? My if formula: =IF(accounts[@[Product ACV]]>1000000,"T","F") works fine. With this I get T or F. However when I use this =IF(accounts[@[Pr...
dscheikey
Nov 26, 2022Bronze Contributor
miro-subasic You probably have a typing error in your formula. Maybe one bracket is not closed or one bracket too many. Can you please upload a screenshot or a sample file.
- miro-subasicDec 11, 2022Copper Contributorthanks dscheikey for your reply. There is no typing error. As written above this works: =IF(accounts[@[Product ACV]]>1000000,"T","F"). This gives either T or F as a result.
Without changing anything in the formula, just typing True instead of T and False instead of F it shows me the formula instead of True or False