Help with an IF statement
Posted by Rick M on February 01, 2001 12:24 PM
I need an IF statement that will display a text "NO" if one cell compared to another cell is not divisible by a whole number.
Example:
cell A1: 20
Cell B1: 42
answer 42/20=2.1 therefore "NO"
The only variable is the quantity in A1 and B1 change depending on input.
Next time A1 could equal 4 and B1 could equal 7
Any clue?
Thanks