I need to come with a formulae which outputs the following:
1) if colour is Red and number is less than 40, put in 40, otherwise take D2 from C2. this part of forumale works fine. I have used and "if(and(" formulae for this.
2) where I need help on is I need to layer on top another scenario where if the colour is orange and number is less than 50, put in 50 instead other take D2 from C2.
what do I need to do add to the If(and forumale to get part 2 to work?
Bookmarks