if function
 

in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
numbers are = anyone know what is going on here?

if function
 

Probably they aren't equal, although they display as equal. Format both as General, widen the columns and you'll probably see
digits differing.
Use the ROUND() function to get around this.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jason2444" wrote in message ...
| in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
| =IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
| numbers are = anyone know what is going on here?

if function
 

"jason2444" wrote:

in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
numbers are = anyone know what is going on here?

I ment to type in =IF(A1<=B1

if function
 

Because your formula says "K1" and you said the cell is "B1".
Try this:

=IF(A1<=B1,"Correct","Overcharged")

HTH,
Paul

--

"jason2444" wrote in message
...
in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but
the
numbers are = anyone know what is going on here?

if function
 

Jason,

Sounds like it could be a rounding error.
Try this formula
=A1=K1
If it returns false then the numbers aren't equal, increase the decimal
places to see the difference

Mike

"jason2444" wrote:

in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
numbers are = anyone know what is going on here?

if function
 

hi,
i would check to see how many decimal places the two number extend. you may
have them formated show 2 but the number themselves may have more.
$30.831 would be greater than $30.830
by the way...what's in K1???

regards
FSt1

"jason2444" wrote:

in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
numbers are = anyone know what is going on here?

if function
 

When you run into things like this it's helpful to put this in a spare cell
=A1=K1 If that returns TRUE, the cells are equal. It's likely the formatted
display makes them look equal when they're really not equal. In that case,
look at the cell contents not the formatted display.

Tyro

"jason2444" wrote in message
...
in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but
the
numbers are = anyone know what is going on here?