The Journal

Google Sheets: Using Custom Formulas in Conditional Formatting

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...
The Journal

Google Apps: Applying Conditional Formatting Across Sheets

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...
thetechedvocate.org

Make Nested Excel IF Statements With Multiple Conditions Work for You

Excel is a powerful tool that can save you a lot of time and effort in analyzing data. One of its most commonly used functions is the IF statement. An IF statement tests a condition and returns one ...
IEEE

Intelligent Fraud Detection in Financial Statements Using Machine Learning and Data Mining: A Systematic Literature Review

Abstract: Fraudulent financial statements (FFS) are the results of manipulating financial elements by overvaluing incomes, assets, sales, and profits while underrating expenses, debts, or losses. To ...
C&EN

High Color-Purity Red, Green, and Blue-Emissive Core–Shell Upconversion Nanoparticles Using Ternary Near-Infrared Quadrature Excitations

State Key Laboratory on Integrated Optoelectronics, College of Electronic Science and Engineering, Jilin University, Changchun, Jilin 130012, China ...