Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

If formula error for calculated column

Hi Experts   I am getting an error with the following If formula second IF cannot see my mistake.   TWC_1 = IF(QUOTEMAN[TRUSTWITHCONSEQ] = 1, "TWC",     IF( QUOTEMAN[TRUSTWITHCONSEQ] = 0 && Q...
Need Help
  • JorgePinho's avatar
    JorgePinho
    3 years ago

    Try this "NOT(ISBLANK(QUOTEMAN[Firm Price (Exc VAT)(£)])) instead of "QUOTEMAN[Firm Price (Exc VAT)(£)]<> BLANK()"

JorgePinho's avatar
JorgePinho
Solution Sage
3 years ago

Try this "NOT(ISBLANK(QUOTEMAN[Firm Price (Exc VAT)(£)])) instead of "QUOTEMAN[Firm Price (Exc VAT)(£)]<> BLANK()"