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
Bookmarks