There are instances when you need to know whether a number is even or odd. Let’s say you are calculating sales by sales person. But because the name of your company is “Even Up, Inc” the sales folks get an extra bonus for sales made on even days!
To figure which days are odd and which are even, you can simply use the ISODD or ISEVEN functions.
The result from this formula will be either TRUE or FALSE. If the number is even, you will get TRUE, if it is odd, you will get FALSE. (Obviously, if you use the ISODD formula, you will get TRUE if the number is odd and false if the number is even)
Therefore if you use this in conjunction with the IF STATEMENT formula you can really get your desired result.
Lastly, if you want it to be more dynamic, you can perform your calculations right in this formula by NESTING other formulas or calculations in lieu of the “Bonus!” or “No Bonus” text.
Keep Excelling!
Do you like this post? Comment below and / or share on Facebook or Twitter!
No comments:
Post a Comment