I had previously checked the formula to make aure that i was using "0" as
opposed to "O".
I even tried to apply the formula in a new workbook to make sure by copying
your formula and got the same results. It always returns "0" into my formula
cell. When i click on the reference cell (A1) when it ends in the "010"
value it drops that last value (0) from the formula bar. Could this be the
problem?
"Kassie" wrote:

=if(RIGHT(A1,3)="010",$D1,"0") works for me?

Sure you did not use an O, iso a 0?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"MIKE F" wrote:

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!