IF-Formula together with Index and Match

Jörg Schmidt1

Hi, I use the Index + Match formula to calculate individual prices with multiple criteria. It works

Now, I want to add an "IF"-formula in order to calculate and show only in these rows where a certain course is requested (f.e. "Angebot Premiumkurs"). Unfortunately I receive "unparseable" - any idea why?

The number 12376 is a price added to the individual calculated factors

Kelly Moore

Hey @Jörg Schmidt1

In your IF statement, you need an @row as part of your column name.

=IF(Marketingname@row="Angebot Premiumkurs";

Also, unless you wish your ending zero to be treated as a text string, remove the quotes from around the zero. This will allow the character to be treated as a number vs you forcing it to be text.

Does that work for you?

Kelly

Kelly Moore

Hey @Jörg Schmidt1

In your IF statement, you need an @row as part of your column name.

=IF(Marketingname@row="Angebot Premiumkurs";

Also, unless you wish your ending zero to be treated as a text string, remove the quotes from around the zero. This will allow the character to be treated as a number vs you forcing it to be text.

Does that work for you?

Kelly

Jörg Schmidt1

Hi Kelly, thank you so much for helping. I love to see it working :-)

Have a nice weekend

kind regards Joerg 😁