i am referencing a 9 digit number. they are all formated as follows:
123456.xxx where xxx can be 001 thru 012. The formula works for all values
other than the "010". In the formula bar for the referenced "A" column cell
it drops the last zero even though the sheet is formatted and displays as
123456.010

Thanks.

"Kassie" wrote:

If it is dropped, Excel will evaluate ?01, iso 010. Iow, if your number was
1234010, and the last 0 is dropped, Excel will evaluate 401, and of course
return 0. That would depend on the number of digits in your number? Excel
handles 15 digits only. On the other hand, it would then do the same with
the other numbers as well? What is the exact number that you are evaulating?

--
Hth

Kassie Kasselman
Change xxx to hotmail


"MIKE F" wrote:

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!