software

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
www.officekb.com/Uwe/Forums.a...tions/200605/1

Use ROUND function to keep 2 decimal places

HTH
--
APquot;Susana C via OfficeKB.comquot; lt;u21183@uwegt; a écrit dans le message de news:
5ff2c8049b735@uwe...
gt;I am using an If function to see if column H matches either I, j, K or L.
gt; All of these columns contain numbers ranging from $0.00 to $20,000.00.
gt;
gt; My if statement is not working because column H contains solid numbers
gt; such
gt; as $8.51 but the other colums contain $8.512. Alothough I can change the
gt; format to view only the two decimal places, it does not change the acutal
gt; number. Even when I truncate the numbers, the appearance changes, but the
gt; actual value of the cell does not.
gt;
gt; Please help!!
gt;
gt; Thank you.
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...tions/200605/1