Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I'm trying place a formula in cell C3.
IF(AND(K3="","",IF(LEFT(K3)="4",M3="a"),"CTA","STD "),IF(AND(K3="","",IF(LEFT(K3)="5",M3="a"),"STA"," Gil")) I'm trying to have cell C3 show CTA if the number in K3 starts with a 4 and the letter in M3 is "a". And if the number in K3 starts with a 4 and the letter in M3 is "c" have C3 show STD. Or if the number in K3 starts with a 5, and M3 is "a" have C3 show STA, or if K3 starts with a 5 and M3 is "c" then C3 would show Gil. Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with formula syntax | Excel Discussion (Misc queries) | |||
formula syntax. | Excel Discussion (Misc queries) | |||
Syntax of formula | Excel Worksheet Functions | |||
Formula Syntax | Excel Worksheet Functions | |||
Formula syntax {;;;} | Excel Worksheet Functions |