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