Two separate IF statements in one expression.

[neena123]

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.

[rubenmarin · Accepted solution]

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))

[neena123]

Thanks everyone for replying and for all your help!