chriskenny
New member
- Joined
- Jun 20, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- excel 2013
M | N | O | P | Q | R | S |
I put staff no. in here | I have a formula in here when it generates sales person name after entering her staff no. in column M - formula is =INDEX('Staff info'!$a$3:$a$22,match($Q2,'Staff Info'!$G$3:$G$22,0)) | Formula in here for single sales =IF(G34="YES,25%,20%)*12 | I have this as where I enter Y OR N if split commission | Same as M | Same as N | Split amount goes |
So what I would like to do is:
1. if I put Y in column P I would like the figure in column O divided by 2 and this amount put into column O & S
2. If I put N in column P then the whole figure would go in column O
I hope this makes sense
Thank you in advance
So what I would like to do is:
1. if I put Y in column P I would like the figure in column O divided by 2 and this amount put into column O & S
2. If I put N in column P then the whole figure would go in column O
I hope this makes sense
Thank you in advance