• Std fxs
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom fxs (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • Contact
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
XLf(x)s = Excel Functions
XLf(x)s = Excel Functions
Excel functions and formulas
Skip to content
  • Std fxs
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom fxs (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • Contact
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
Category: Logical

Category: Logical

Home Standard functions Archive for category "Logical"

SimpleANBox

SimpleANBox
ANmar Basic Math / DATE / Date and Time / Formulas - combined functions / IF / IFERROR / Logical / Math and Trig / SUM / TODAY / WEEKDAY / Worksheet  DATE / IF / IFERROR / SUM / TODAY / WEEKDAY January 21, 2019 January 21, 2019

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time with technology (since 1997) I …

Full article"SimpleANBox"

Scorring, saving multiple outputs in 1 number

Scorring, saving multiple outputs in 1 number
ANmar Basic Math / Conditional Formatting / Formulas - combined functions / Logical / Non-functions / Standard functions December 10, 2018 January 21, 2019

I have seen this practice before several locations Returning multiple outputs in 1 single number. for example

Full article"Scorring, saving multiple outputs in 1 number"

Compare2, a tool to compare two sheets using formulas

Compare2, a tool to compare two sheets using formulas
ANmar Conditional Formatting / Formulas - combined functions / IF / Logical / Standard functions December 5, 2018 December 6, 2018

Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in file1 and file2. Make sure …

Full article"Compare2, a tool to compare two sheets using formulas"

BMI Calculator

BMI Calculator
ANmar Basic Math / IF  BMI / Calculator / Convert December 5, 2018 December 5, 2018

A simple calculator, how come we do not have one like this?

Full article"BMI Calculator"

Skills Grid

Skills Grid
ANmar Conditional Formatting / Data Validation / Formulas - combined functions / IF / IFERROR / Logical / Lookup and References / Names / Non-functions / OFFSET / Standard functions / VLOOKUP / Worksheet October 26, 2018 December 5, 2018

A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each

Full article"Skills Grid"

Text-to-Columns, dynamically using formulas

Text-to-Columns, dynamically using formulas
ANmar IFERROR / Len / MID / SEARCH April 3, 2018 April 3, 2018

I often use the technique of concatenating columns into 1 cell with separators. Something like the CSV, 1 line that has all values for a single row (all columns for …

Full article"Text-to-Columns, dynamically using formulas"

Posts navigation

1 2 3 4

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Other websites

  • ANmar.Systems
  • BoldCodes
  • MyResume.cc
  • Folder8
  • Alwah.net – ألواح
  • ArabicNames.US
  • Excelication.com

Linkedin profile

ANmar Amdeen
Powered by Kahuna & WordPress.
©2018 XLf(x)s=Excel Functions | ANmar.Systems
Back to Top

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close