i'm trying to write an if statement with nested functions that states if a the value in column d is "CDRN PORTAL PROSPECT" or the date in column m plus 90 days or the date in column l plus 90 days is greater than or equal to the date in cell x1, then take the dollar value from column w otherwise it is zero. however, the formula seems to work for some cells but not others. can someone help? here is the formula as it is written:
=IF(AND($D3="CDRN Portal Prospect",($M3+90)>=X$1,($L3+90)>=X$1),$W3,0)
Aucun commentaire:
Enregistrer un commentaire