| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function based on right value
I am trying to write an if formula based on the following.
=IF(RIGHT($A1,3)="001",$D1,"0") I have successfully written that formula for all values that end in the A column with "001" thru "009" and "011" & "012". The problem I am having is with "010". It always retunns 0 into my formula cell. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which function to use? Trying to ref a cell based on another. | New Users to Excel | |||
| Add certain cells based on a function | Excel Worksheet Functions | |||
| Sum function based on format | Excel Worksheet Functions | |||
| function based on result of same function | Excel Discussion (Misc queries) | |||
| Old, LOTUS 1-2-3 based function | Excel Worksheet Functions | |||
Threaded Mode
