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

Ask a question j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Last answered 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 
moins plus
j1969c, Good afternoon.

Try to use:


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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!