| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Linear Mode
