ExcelBanter - View Single Post - How do I use a wildcard or multiple of a cell value in a formula?

Thanks guys, has really helped!

"Gary L Brown" wrote:

=if(mod(a1,b1)=0,"Is a multiple","Has a remainder")

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

"Vic" wrote:

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?!