Quote Originally Posted by DocAElstein View Post
Hi

To cover the situation of Single or blank meaning the same then the formula would be
=IF(OR(E6="single",E6=""),IF(Payments!G6<=5,Payments!G6,5),IF(Payments!G6<=10,Payments!G6,10))
Worksheet: Subscriptions

I think the following adaptation of that formula to your supplied data seems to give the result you wanted in the January column in Subs.

So this is your Payments
Row\Col
E
F
G
H
1
£29
£0
2
3
Status
Subs Due
Jan
Feb
4
 Single
£60
5
 Couple
£120
£25
6
 Single
£60
£4
7
8
Worksheet: 2018 Payments

Here is the Subs worksheet:
Row\Col
E
F
G
H
1
£14
£0
2
3
Status
Subs Due
Jan
Feb
4
 Single
£60
£0
5
 Couple
£120
£10
6
 Single
£60
£4
7
Worksheet: 2018 Subs
Row\Col
G
4
=IF(OR(E4="single",E4=""),IF('2018 Payments'!G4<=5,'2018 Payments'!G4,5),IF('2018 Payments'!G4<=10,'2018 Payments'!G4,10))
5
=IF(OR(E5="single",E5=""),IF('2018 Payments'!G5<=5,'2018 Payments'!G5,5),IF('2018 Payments'!G5<=10,'2018 Payments'!G5,10))
6
=IF(OR(E6="single",E6=""),IF('2018 Payments'!G6<=5,'2018 Payments'!G6,5),IF('2018 Payments'!G6<=10,'2018 Payments'!G6,10))
Worksheet: 2018 Subs

Alan
Thanks ever so much Alan, this works perfectly fine. I will let the trustees know about your invaluable contribution to the charity record keeping.

Thanks once again