OK, posto je situacija specificna i ne da se resiti standardnim nacinom, napravio sam ti funkciju koja ce tu zavrsiti to sto ti treba.
U Excel-u ides Tools>Macro>Visal Basic Editor. Zatim ides na Insert > Module. Tu upises sledeci kod:
Code:
Function NineOptions(Value As Integer, Option1 As Integer, Option2 As Integer, _
Option3 As Integer, Option4 As Integer, Option5 As Integer, _
Option6 As Integer, Option7 As Integer, Option8 As Integer, _
Option9, Result1 As String, Result2 As String, Result3 As String, _
Result4 As String, Result5 As String, Result6 As String, _
Result7 As String, Result8 As String, Result9 As String) As String
'Author: Shadowed
'Made for: Mina7
Select Case Value
Case Option1: NineOptions = Result1
Case Option2: NineOptions = Result2
Case Option3: NineOptions = Result3
Case Option4: NineOptions = Result4
Case Option5: NineOptions = Result5
Case Option6: NineOptions = Result6
Case Option7: NineOptions = Result7
Case Option8: NineOptions = Result8
Case Option9: NineOptions = Result9
End Select
End Function
Zatim normalno koristis kao bilo koju funkciju. Prvi parametar ti je ta celija ciju vrednost proveravas, narednih 9 parametara su vrednosti koje ona moze imati i narednih 9 vrednosti koje treba vratiti). Primer:
=NineOptions(A1,1,2,3,4,5,6,7,8,9,"jedan","dva","tri","cetiri","pet","sest","sedam","osam","devet") ispisuje slovima cifru koju upises u celiju A1.
[Edit: Ispravljen kod.]
[Ovu poruku je menjao Shadowed dana 24.10.2005. u 11:12 GMT+1]