Aug 24 2021 06:57 PM
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)
Thank you so much
Aug 24 2021 07:19 PM
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))