electricsuk
Board Regular
- Joined
- Mar 26, 2008
- Messages
- 61
does someone know if I can have a formula that works along the lines of
if a cell is a multiple of another cell
for example if
A1=5 and A2=25 and A3=98 , I need a formula that says if A2/A1 = a whole number then = A3 and it will return me 98.
or same method to get the same answer hopefully...
if A1 is a multiple of A2 then return A3 which will equal 98.
CHEERS
if a cell is a multiple of another cell
for example if
A1=5 and A2=25 and A3=98 , I need a formula that says if A2/A1 = a whole number then = A3 and it will return me 98.
or same method to get the same answer hopefully...
if A1 is a multiple of A2 then return A3 which will equal 98.
CHEERS