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

Ask a question j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Last answered on Sep 11, 2015 at 12:15 PM by Mazzaropi
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?

plus moins
j1969c, Good afternoon.

Try to use:


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

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!