the above code works fine but i need to tweek it![]()
=IF(OR($AN3="Error",$AN3="Call Incomplete,"),"Call Incomplete","Call Complete")
if $k3 is "N/A" then "call complete"
otherwise check if either "$AN3 = "Error" or if $AN3 = "Call Incomplete" then "call incomplete"
otherwise "Call Complete"
Bookmarks