If if if

[guscrouchend]

Hi,

At the moment, a column is populated by:

=IF(ISERROR(MATCH($C5,PriceTable!$F$1:$F$9,0)),"Grad","Senior")

So, if the value in column C is one of the values in range PriceTable!$F$1:$F$9, then the cell is "Senior". If not, it is "Grad".

What I would like is to introduce the third value "Trial" if the value in column C contains an asterisk.

If it does not contain an asterisk, the cell must follow the above formula.

Does anyone know if or how this could be done?

 

[e17nel]

Hello, if you want it to return Trial if the only thing in Column C is an * the try:

=IF(C5="*","Trial",IF(ISERROR(MATCH($C5,PriceTable!$F$1:$F$9,0)),"Grad","Senior"))

Hi,

At the moment, a column is populated by:

=IF(ISERROR(MATCH($C5,PriceTable!$F$1:$F$9,0)),"Grad","Senior")

So, if the value in column C is one of the values in range PriceTable!$F$1:$F$9, then the cell is "Senior". If not, it is "Grad".

What I would like is to introduce the third value "Trial" if the value in column C contains an asterisk.

If it does not contain an asterisk, the cell must follow the above formula.

Does anyone know if or how this could be done?

 

[jardenp]

=IF(ISNUMBER(SEARCH("~*",C5)),"Trial", IF(ISERROR(MATCH($C5,PriceTable!$F$1:$F$9,0)),"Grad","Senior"))

 

[jardenp]

Side note: searching for "*" will be interpreted as a wildcard search. You must add a tilda before the asterisk.

My formula above is not limited to the cell containing only an asterisk.

 

[e17nel]

Actually, the "*" isn't interpreted as a wildcard unless you are donig the search formula. If you use the formula I suggested, it will return Trial if the only thing in the cell is an *.

However, your formula will cover if there are other things in the cell besides just an *.

Side note: searching for "*" will be interpreted as a wildcard search. You must add a tilda before the asterisk.

My formula above is not limited to the cell containing only an asterisk.

 

[jardenp]

I only intended that as an explanation for why my formula included a tilda.

 

[guscrouchend]

That's absolutely fantastic, Thanks a lot