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

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

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

=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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509310

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

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

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

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