- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi, I need a help with the IF function.
Here is are the situation,
(If No of Mod is 1)
If End Gable_Left is tick, No of Gable should be 1
If End Gable_Right is tick, No of Gable should be 1
If both End Gable_Left & End Gable_Right are tick, No of Gable should be 2
If non is tick, No of Gable should be 0
(If No of Mod is 2)
If End Gable_Left is tick, No of Gable should be 2
If End Gable_Right is tick, No of Gable should be 2
If both End Gable_Left & End Gable_Right are tick, No of Gable should be 3
If non is tick, No of Gable should be 1
(If No of Mod is 3)
If End Gable_Left is tick, No of Gable should be 3
If End Gable_Right is tick, No of Gable should be 3
If both End Gable_Left & End Gable_Right are tick, No of Gable should be 4
If non is tick, No of Gable should be 2
until now, if No of Mod is 2, I able to make No of Gable turns 2 if either Left or Right is tick. But if both Left and RIght is tick, the No of Gable is still 2, not change to 3. 😖
Solved! Go to Solution.