Quote Originally Posted by DocAElstein View Post
Hi lome,

I am not sure if I have the logic correct of what you want.
I find it helpful to put theses things clearly into words
This is what I understand…
A formula is wanted in subscriptions
In subscriptions column E I may have “single” or “couple” .
I only need to check for single: If I do not have single then I assume I have couple.

So my logic:
If Single then ____ ; Else _____
____ will be case single
_____ will be case couple

____ and _____ will be very similar, differing only by
____ having a 5 in it
_____ having a 10 in it


=IF(E6="single",IF(Payments!G6<=5,Payments!G6,5),IF(Payments!G6<=10,Payments!G6,10))
Worksheet: Subscriptions

If I have not got it right, then can you upload two workbooks, with just a small amount of data. Desensitise the data ( make names up etc.. but pick the data carefully so that it demonstrates typical scenarios. )

One file should be the “Before” - so what you have before you enter any payment.

The “after” should be hand filled in by you to show what you want the formula to do, that is to say what results you want to have. And say what you will be wanting to be doing to get those results.

Alan
Alan,

Thanks for looking at this post. I forgot to mention that when a member's status is not know, column E is left blank and the assumption in subscriptions is that the member is single. So you can have single, couple or blank in column E, but when blank, the formula in subscriptions assumes single and allocate £5. Sample Model.xlsx

I used insert Image as I cannot see an option to upload file

In the file:

Row4 where there was no payment
Row5 where member is a couple and paid subs with donation
Row6 where member is single and paid less than required subs

Thanks once again