mardi 4 août 2020

Hi am am struggling with a formula

I have an excel spreadsheet with the following formula in column "L":

=IF($A4="","",IF($J4>=$K4,"",IF($J4="","",if($M4<>"Released","",$J4+90)))

I am trying to populate Column "L" with a date 90 days from column "J" but only if either Column M=Released or if Column K is greater than J on any other occasion Column "L" must remain blank

I can get the formula to work if I remove the IF($J4>=$K4,"", element and just have

=IF($A4=""," ",IF($M4<>"Released","",IF($J4="","",$J4+90)))

or just with this element

=IF($A4="","",IF($J4>=$K4,"",IF($J4="","",$J4+90)))

but when I try to add IF($J4>=$K4,"" and IF($M4<>"Released","" together I can't get it to work

Appreciate any advice

Aucun commentaire:

Enregistrer un commentaire