how to work if function in excel in longer Logical i.e ( if a1="a","apple",if(a1="b", "ball",if(a1="c","cat",if(a1="d", "dog",if(a1="e","egg",if(a1=f","fan"............... so on) its logical is too long that why it is not working , how can do this process in excel .
