View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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";
}