Report

=IF(F9:F46="CTF",I9,"") [Solved]

Ask a question j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Latest answer on Sep 11, 2015 12:15PM
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?
See more 
Helpful
+0
moins plus
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
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!