=IF(C1="7-14",7,IFC1="8-20",12,"")

which will return the value to the calling cell.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
oups.com...
How can I create in Excel function like this:

IF (C1 == "7-14"){
cout << "7";
}
else if (C1 == "8-20"){
cout << "12";
}