how to work if function in excel in longer Logical?

Sohail

New member
Joined
Jun 28, 2008
Messages
12
Reaction score
0
Points
1
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 .
 
Back
Top