Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
0.1 to 0.99 not recognised or calculated when results from formula
Problem- Excel not recognising or counting values between '0.01 to 0.99' in
cells containing formula. Exact sheet can be downloaded at- http://www.aensia.com/test.zip My worksheet- A B C D E 1 Stock Open Sale return Sale Stock should be Calculate if D=0.2 2 0.65 0.45 0.2 0.2 3 5 1 4 0 4 2 2 0 0 5 7 6.8 0.2 0 6 6 5.5 0.5 0 7 9 8.1 0.9 0 Stock should be i.e. D2 to D7 contains formula =A2+B2-C2 I want to calcuate stock which is 'less than 0.2' in 'stock should be' i.e. D2 to D7. I used formula =IF(D2=0.2,D2,0) As you can see it gives right value for D2 but is not giving right value for D5. Can anyone help. In my sheet excel is not recognising values starting from 0.01 to 0.99 in D2 to D7 as it is calculated by formula. You can download the original sheet giving problem at- http://www.aensia.com/test.zip |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to autofil a formula that is not recognised? | Excel Discussion (Misc queries) | |||
Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel | Excel Worksheet Functions | |||
Formating not recognised in lookup formula | Excel Discussion (Misc queries) | |||
Can Function results be calculated? | New Users to Excel | |||
= not recognised as formula (sometimes) | Excel Discussion (Misc queries) |