Thread: How do I use a wildcard or multiple of a cell value in a formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote