Monday 24 January 2022

Today I learned how to use the QUOTIENT function in Excel ...

So, being the world's laziest person, I wanted to have Excel do some very very simple division and return the whole number portion, without the remainder.

I've got a cell that contains a total amount e.g. 1,234  and a few rows that contain "exchange rates".

For each row, I wanted to divide the total e.g. cell C1 by the exchange rate, and return the whole number.

This: -

QUOTIENT function

gave me what I needed i.e. the QUOTIENT() function.

For each row, I "anchored" cell C1 as the first argument to the function ( the numerator, the number "on top" of the division ) and the exchange rate cell as the second argument ( the denominator ) e.g.

I then used the value of the QUOTIENT() function to calculate the total i.e. voucher face value vs. the quotient.

Yeah, I know, dividing 342 into 1234 ain't that hard but ... automation is everything ....

No comments:

Visual Studio Code - Wow 🙀

Why did I not know that I can merely hit [cmd] [p]  to bring up a search box allowing me to search my project e.g. a repo cloned from GitHub...