Can anyone advise me the problem of this IF formula

Copper Contributor

Hi,

Could someone have a look the below formula and advise me which part went wrong and how can I fix it?

 

=IF(AN15="Standard Banners",U13/1000*0.49),IF(AN15="Link Tracking only", U13/1000*0.15)

Onki_Pun_0-1629856578579.png

Thank you so much

1 Reply

@Onki_Pun 

You copied two IF-formulas one after the other. Excel cannot evaluate such a construct,

You have to nest the functions:

=IF(condition1,value1,IF(condition2,value2,value_if_nothing_matched))