Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two separate IF statements I am trying to put into one expression in a straight table. It is only giving me back -1 and nothing else.
My expression is:
=IF([Payment Terms]='12',[Extended Amount]*0.02)
OR
IF([Bill To]='24973618' OR '24973619',[Extended Amount]*0.12)
How can I make this expression work without having to make two separate columns for it. Any help is much appreciated.
I missed something in the 2nd if:
=If([Payment Terms]='12',[Extended Amount]*0.02,
If([Bill To]='24973618' OR [Bill To]='24973619',[Extended Amount]*0.12))
Thanks everyone for replying and for all your help!