If condition: help needed

[DocAElstein]

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

[lome53]

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