Help with IF statement

[skibbz]

Hi All,

I would be very grateful if someone could answer my query.

Under the 'Info' tab of the attached workbook, I have some rules I would like to apply to an IF formula in Column K

Any help would be most appreciated.

Best,

Skibbz

[AliGW]

OK, so instead of this:

Formula????

please add some manually calculated outcomes (maybe the first 5-10 rows) so that we can see what you are after. Thanks!

PS Yes, I have read your instructions in the workbook. I still want to see some expected results, please.

[Sam Capricci]

As Ali noted, it is difficult to determine what outcomes you want. This may be what you want...
=IF(J2="paid",E2,IF(AND(J2="awaiting payment",TODAY()<B2),C2,IF(AND(J2="awaiting payment",TODAY()>C2),"overdue","")))
OR, if this part of your note says you want a week added to the date

If Status Tab = 'Paid', then add week commencing date in Column K using 'Paid date'

then adjust to this...
=IF(J2="paid",E2+7,IF(AND(J2="awaiting payment",TODAY()<B2),C2,IF(AND(J2="awaiting payment",TODAY()>C2),"overdue","")))

[skibbz]

Sambo Kid, Absolutely spot on, thank you!
Best Wishes,
Skibbz