Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"; } |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"; } |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"; } |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"; } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |