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

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

[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

[Gary L Brown]

=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?''.


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

[Vic]

Thanks guys, has really helped!

"Gary L Brown" wrote:

> =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?''.
>
>
> "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?!