View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike F Mike F is offline
external usenet poster
 
Posts: 9
Default 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!