Excel - If Function
Closed
clchamberlain
Posts
1
Registration date
Friday September 25, 2015
Status
Member
Last seen
September 25, 2015
-
Sep 25, 2015 at 02:58 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 25, 2015 at 04:18 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 25, 2015 at 04:18 PM
Related:
- Excel - If Function
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Agp function - Guide
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 25, 2015 at 04:18 PM
Sep 25, 2015 at 04:18 PM
clchamberlain, Good afternoon.
I suggest to you a more manageable approach to its variables.
It is better and much easier to locate and change if necessary to maintain in your spreadsheet.
Create a small but efficient table.:
.....X.........
1..Meal
2..Room
3..Rent
4..Housing
5..Lodging
Try to use:
Matricial Formula
=IF(COUNT(SEARCH(X1:X5,F2)),"Dining",IF(COUNT(SEARCH(X1:X5,F2)),"Housing",""))
SHIFT + CTRL + ENTER after typed the formula
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I suggest to you a more manageable approach to its variables.
It is better and much easier to locate and change if necessary to maintain in your spreadsheet.
Create a small but efficient table.:
.....X.........
1..Meal
2..Room
3..Rent
4..Housing
5..Lodging
Try to use:
Matricial Formula
=IF(COUNT(SEARCH(X1:X5,F2)),"Dining",IF(COUNT(SEARCH(X1:X5,F2)),"Housing",""))
SHIFT + CTRL + ENTER after typed the formula
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
