Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Check if a Whole Number can be divided by another number

To check if one a whole number is divisible by another number, we will be using the IF function in combination with the INT function. In our example, we will be checking if certain numbers are divisible by 4 without leaving a remainder. Here is how we’ll achieve this: To see if a whole number can [...]

Use the IF function to compare columns and return a result

In this example, we will be using the IF function to compare columns and return a specific result instead of the standard TRUE or FALSE. We will have values in column A and B and we will compare them to see if if Column A is greater than or equal to Column B or if [...]