Gubbelille
New Member
- Joined
- Oct 3, 2021
- Messages
- 8
- Office Version
- 2019
- Platform
- Windows
Hi yall!
Im a beginner in this and cant get it to work properly.
So lets say in a1 i have a certain specific text that tells a tool number, in b1 i have 1 of 4 places it will be. In c1 i want to give it the right program based on these values. I can get it right with one but as we have 9 different tools designated to 4 different spots, it all depends on toolname and toolspot that give the number.
Something in the style like if(and(a1="tool1",b1="spot1";"50")
And can u add more after that, that will change spot from 1,2,3,4 and tool1,2,3 and so on and give different value in the end?
Hope this describes it right as english is my second längtade!
Im a beginner in this and cant get it to work properly.
So lets say in a1 i have a certain specific text that tells a tool number, in b1 i have 1 of 4 places it will be. In c1 i want to give it the right program based on these values. I can get it right with one but as we have 9 different tools designated to 4 different spots, it all depends on toolname and toolspot that give the number.
Something in the style like if(and(a1="tool1",b1="spot1";"50")
And can u add more after that, that will change spot from 1,2,3,4 and tool1,2,3 and so on and give different value in the end?
Hope this describes it right as english is my second längtade!