Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEFT Worksheet function
=IF(LEFT(G7,2) = 17,"Dep", "Amort")
I constructed the above function to return Dep if the first two digits starting from the leftmost digit in cell G7 is 17 and return Amort otherwise, please help. This formula looks so right to me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
Evaluating Today() function only once in a worksheet | Excel Worksheet Functions | |||
Offset function referencing worksheet | Excel Discussion (Misc queries) | |||
changing type style and colour within a worksheet function | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions |