Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel IF Function Help!!! plz?
Ok I am having problem with Excel IF Function. Here is the problem. (Cell A1) 10209.0 - (Cell A2) 10208.7 (Cell A5) = A1 - A2 So (Cell A5) i have the answer of 0.3 Then on (Cell A7) i put IF Function =IF(A5=0.3,2,0) I put if A5 is equal 0.3 then give me 3 or else 0 But the answer Excel gave me is "0" WHY ???? A5 IS = 0.3 WHY ?? HELP Plz.... Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions |