=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>"
Solved/Closed
j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
-
Sep 12, 2015 at 09:29 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 13, 2015 at 02:18 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 13, 2015 at 02:18 PM
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.
=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:
- =IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>"
- Aspire 3 15 keyboard light - Guide
- Garageband ios 15 download - Download - Musical production
- Iphone 15 release date - Home - IOS
- Android 15 release date - Home - Android
- How to factory reset dell inspiron 15 - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 13, 2015 at 02:18 PM
Sep 13, 2015 at 02:18 PM
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
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