Hi All
So I am using the following formula to calculate payment entitlements:
=IF(L145="Scheme A",P145*30,P145*60)
So Scheme A pays £30 per day and Scheme B pays £60 a day (in the above if Column L contains "Scheme A" it multiplies P by 30, if L doesn't contain "Scheme A" then P by 60) . This...