» Determining Divisibility
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Determining whether each of the numbers listed in column A is divisible by the corresponding number in column B.
Solution:
Use the IF and MOD functions in the following formula:
=IF(MOD(A2,B2)=0,"Divisible","Non-Divisible")
Book Store:
Recommended Books:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Word 2002: The Complete Reference
- The 22 Immutable Laws of Branding
- Microsoft Excel 2002 Simply Visual
- Special Edition Using Microsoft Access 2002
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.
