problem with 'IF'
 

How can I create in Excel function like this:

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

problem with 'IF'
 

=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";
}

problem with 'IF'
 

Depends on where you want the result and whether C1 is a variable or a range
reference.

Select Case Range("C1").value
Case "7-14"
msgbox "7"
Case "8-20"
msgbox "12"
End Select

--
Regards,
Tom Ogilvy



" wrote:

How can I create in Excel function like this:

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

problem with 'IF'
 

or if you meant as a formula

=if(c1="7-14",7,if(c1="8-20",12))

--
Regards,
Tom Ogilvy

" wrote:

How can I create in Excel function like this:

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