Lookup for word in company name
Closed
Wsamuels
Posts
1
Registration date
Monday May 24, 2010
Status
Member
Last seen
May 26, 2010
-
May 26, 2010 at 11:31 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 26, 2010 at 11:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 26, 2010 at 11:45 AM
Related:
- Lookup for word in company name
- Word apk for pc - Download - Word processors
- Number to text in word - Guide
- How to insert photo in word for resume - Guide
- Tick symbol in word - Guide
- Backspace not working in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 26, 2010 at 11:45 AM
May 26, 2010 at 11:45 AM
What you mean by "combine more then one criteria"
if you mean by do if A is true AND B is true, then your first formula is example of that
AND(cond1, cond2, ...)
OR(cond1, cond2,...)
If you meant nested if then
=IF( cond, TT, FF)
where if cond is found to be true it looks at TT
and if cond is found to be false, it looks at FF
now FF and TT can be values or it can be formula or it can be other IFstatement
=IF(COND, "Apple", "Orange") 'values
=IF(COND, TODAY(), A1 * B1) 'formula
=IF(COND, IF(COND2, "Apple", "Orange"), FF) 'nested if
You can have upto 7 nested IFs
if you mean by do if A is true AND B is true, then your first formula is example of that
AND(cond1, cond2, ...)
OR(cond1, cond2,...)
If you meant nested if then
=IF( cond, TT, FF)
where if cond is found to be true it looks at TT
and if cond is found to be false, it looks at FF
now FF and TT can be values or it can be formula or it can be other IFstatement
=IF(COND, "Apple", "Orange") 'values
=IF(COND, TODAY(), A1 * B1) 'formula
=IF(COND, IF(COND2, "Apple", "Orange"), FF) 'nested if
You can have upto 7 nested IFs
