=IF(F9:F46="CTF",I9,"")

Solved/Closed
j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
- Sep 11, 2015 at 11:12 AM
Mazzaropi
Posts
1965
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 18, 2022
- Sep 11, 2015 at 12:15 PM
Hello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") -

I am trying to compute a scheme where if any cell between F9 and F46 have in them the sigla CTF, then give me a the value that is in cell I9.

What am I doing wrong?



1 reply

Mazzaropi
Posts
1965
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 18, 2022
146
Sep 11, 2015 at 12:15 PM
j1969c, Good afternoon.

Try to use:

=IF(ISNUMBER(MATCH("CTF",F9:F46,0)),I9,"")

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0