Combining an IFS and IF(And function

Hi,

Could someone please give me some advice about writing a formula that combines the following (included in cells E2 and E3 of the attached example):

=IFS(D2=0,C2,D2<>0,D2)
=IF(AND(B3="Active",D3=0),D3,C3)

I'd like to insert one formula to copy down in column E.

Many thanks in advance.

Richard

I do not have 365 but try

=IFS(D2=0,C2,D2<>0,D2,AND(B3="Active",D3=0),D3,TRUE,C3)

Thanks for your replies. Unfortunately neither suggestion returns the result I was expecting in F3. =IF(AND(B3="Active",D3=0),D3,C3) returns a zero in my test, whereas your kind suggestions give a 3. Maybe there's a better function or data structure to use.

This ??

=IF(AND(B2="Active",D2=0),D2,IF(D2=0,C2,D2))

Thanks very much John. That's done the trick .
Have a great day.
Richard