How do I use a wildcard or multiple of a cell value in a formula?

V

Vic

This is driving me mad. I'm wanting excel to show if the value in one column
is equal to the value or a multiple of the value in the next column, can
anyone help?! please?!
 
D

Dav

=IF(MOD(C3,D3)=0,"Multiple","not multiple")

Mod checks the remainder as a whole number, if something is a multiple
the remainder is always 0, so making c3 and d3 appropriate to the cells
you are interesting should suffice

If statement is if IF(condition true, then return, else return)

Regards

Dav
 
V

Vic

Thanks guys, has really helped!

Gary L Brown said:
=if(mod(a1,b1)=0,"Is a multiple","Has a remainder")

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
Click to expand...
 
Top