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\")
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\")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks