=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>&quot [Solved]

Ask a question j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Latest answer on Sep 13, 2015 02:18PM
Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated...
Assuming that I am planted in the cell that I want to apply these functions to, what I need to compute is: If cell F21 displays CTF, multiply value in cell I21 15 times, additionally, if cell L21 also displays CTF multiply value in cell O21 15 times, if cell F21 displays anything other than CTF, leave blank, if cell L21 displays anything other than CTF, leave blank.
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

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!