Formula Length
Thank u all
"bpeltzer" wrote:
Create a two-column table that has the 'input' value in the first column (ex
1, 2, 3) and the corresponding 'output' in the second (ex ABC, DEF, GHI).
Then use vlookup; something like =vlookup(L6,table_range,2,false).
--Bruce
"Mukesh Garg" wrote:
Hi all,
I tried the following formula:
=IF(L6=1,"ABC",IF(L6=2,"DEF",IF(L6=3,"GHI",IF(L6=4 ,"JKL",IF(L6=5,"MNO",IF(L6=6,"PQR",IF(L6=7,"STU",I F(L6=8,"VWX","XYZ"))))))))
As in this formula, i can test 9 situations only. but i want to set more
conditions on that cell only.
but excel is not accepting more values than 9. how can i do it?
please suggest.
Regards
Mukesh
|