chriskenny
New Member
- Joined
- Jun 4, 2019
- Messages
- 21
[TABLE="width: 1000"]
<tbody>[TR]
[TD][TABLE="width: 1000"]
<tbody>[TR]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[TD]Q
[/TD]
[TD]R
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]I put staff no.
in here
[/TD]
[TD]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))
[/TD]
[TD]Formula in here for single sales
=IF(G34="YES,25%,20%)*12
[/TD]
[TD]I have this as where I enter Y OR N if split commission
[/TD]
[TD]Same as M
[/TD]
[TD]Same as N
[/TD]
[TD]
Split amount goes
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
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
<tbody>[TR]
[TD][TABLE="width: 1000"]
<tbody>[TR]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[TD]Q
[/TD]
[TD]R
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]I put staff no.
in here
[/TD]
[TD]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))
[/TD]
[TD]Formula in here for single sales
=IF(G34="YES,25%,20%)*12
[/TD]
[TD]I have this as where I enter Y OR N if split commission
[/TD]
[TD]Same as M
[/TD]
[TD]Same as N
[/TD]
[TD]
Split amount goes
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
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