I am using an If function to see if column H matches either I, j, K or L.
All of these columns contain numbers ranging from $0.00 to $20,000.00.

My if statement is not working because column H contains solid numbers such
as $8.51 but the other colums contain $8.512. Alothough I can change the
format to view only the two decimal places, it does not change the acutal
number. Even when I truncate the numbers, the appearance changes, but the
actual value of the cell does not.

Please help!!

Thank you.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200605/1