Previous Topic Next Topic

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

Solved/Closed
j1969c Posts 20 Registration date Friday 28 August 2015 Status Member Last seen 5 April 2016 - 12 Sep 2015 à 21:29
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 13 Sep 2015 à 14:18
Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated...

=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>"CTF","",IF(L21<>"CTF",""))))

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.

Related:

1 response

Réponse 1 / 1
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
13 Sep 2015 à 14:18
j1969c, Good afternoon.

Try to use:
=IF(F21="CTF",I21*15,0)+(IF(L21="CTF",O21*15,0))

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

Similar discussions

Turn on keyboard backlight Acer Aspire Lite
naveen -
HelpiOS -

4 responses
Does Acer Aspire have a backlight keyboard?
batang-akrho1973 -
HelpiOS -

1 response
Enable keyboard backlight Aspire ES 15
iamjag -
Haber -

2 responses
How do I turn on Acer backlight for keyboard?
Christine -
elaina -

4 responses
Acer Aspire 3 activate the keyboard light
Caroline -
djhfhj -

5 responses