Math and Trig – XLf(x)s = Excel Functions

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 August 9, 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 …

Limited Ceiling

ANmar Basic Math / CEILING / Formulas - combined functions / INT / Math and Trig / Standard functions CEILING / INT March 13, 2018 March 14, 2018

The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round number to any value up Unlike ROUND, ROUNDUP and ROUNDDOWN, that …

Count cells with condition – multiple conditions

ANmar COUNTIFS / Formulas - combined functions / Math and Trig / Statistical / SUMIFS COUNTIFS / SUMIFS February 16, 2018 February 16, 2018

We did see who we can get total of a column for a certain month in certain year using SUMIFS. SUMIFS got a sister function, COUNTIFS Which will count how …

Get monthly total from table with dates

ANmar DATE / MONTH / SUMIF / SUMIFS / YEAR December 26, 2017 December 26, 2017

Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded interesting in getting this example …

Calculate hours between two cells

ANmar ABS / Basic Math / Date and Time / Hour / IF / Logical / OR / Standard functions February 27, 2017 March 4, 2017

We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others to help So, when A1 …

Fx to cut long column into two columns

ANmar Formulas - combined functions / INT / Lookup and References / OFFSET / ROW / Standard functions March 19, 2012 March 14, 2018

Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column B starting from B1 to …