hanssorling
New Member
- Joined
- Jan 22, 2014
- Messages
- 8
Hi
I'm creating a worksheet in Excel from Microsoft Navision. I'm sorting out a number of items from the databas and keeping track of the range were the values will end up in the sheet. Once on the sheet I want to add a cell that checks if the values entered bys the user is possible to devide by three using MOD. I have med the formula =IF(MOD(E5;3)>0;"NOT OK") and that checks one cell. If I for example want to check the cells A1 or A2 or A3 if they can be devided by three I have to enter the formula after each other creating a very long string. There is a limitation in Navision and the will create an error if the string of formula is to long so I want the formula to check the cells I enter for the possiblity to be devided by three in some sim ple way. I can't create a script or anything like tha only a formula that will be entered in a cell. How can I do this?
I'm creating a worksheet in Excel from Microsoft Navision. I'm sorting out a number of items from the databas and keeping track of the range were the values will end up in the sheet. Once on the sheet I want to add a cell that checks if the values entered bys the user is possible to devide by three using MOD. I have med the formula =IF(MOD(E5;3)>0;"NOT OK") and that checks one cell. If I for example want to check the cells A1 or A2 or A3 if they can be devided by three I have to enter the formula after each other creating a very long string. There is a limitation in Navision and the will create an error if the string of formula is to long so I want the formula to check the cells I enter for the possiblity to be devided by three in some sim ple way. I can't create a script or anything like tha only a formula that will be entered in a cell. How can I do this?
Last edited: