B bmg59 Mar 3, 2004 #1 What is wrong with this: =if(d2="GROBBLE","Sent",if(d2="RASCLE","SENT","RECV"),"RECV")
M Michael J. Malinsky Mar 3, 2004 #2 Take out the last "RECV"--the amended formula would be: =if(d2="GROBBLE","Sent",if(d2="RASCLE","SENT","RECV")) Mike
Take out the last "RECV"--the amended formula would be: =if(d2="GROBBLE","Sent",if(d2="RASCLE","SENT","RECV")) Mike
J JE McGimpsey Mar 3, 2004 #3 Too many terms Looks to me like this would work: =IF(D2="GROBBLE","Sent",IF(D2="RASCLE","SENT","RECV"))
Too many terms Looks to me like this would work: =IF(D2="GROBBLE","Sent",IF(D2="RASCLE","SENT","RECV"))
