Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |