|
Funtions return wrong result BUG in Execel ???
IF funtion and or funtion returningen wrong result when using decimal numbers.
Exampel:
a1= 300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"ok";"not ok")
this one returns "not ok" which is wrong result !!??
a1=300 b1=303,5 c1=b1-a1 d1=3,5 e1=if(c1<=d1;"ok";"not ok")
this one returns "ok" which is right result.
Be aware that c1 and d1 is equal in both exampels, only the...
|
9 |
12/28/2008 2:26:27 PM |
|
|
Excel Question
I want to past the total results of a filter command to a different column
but the same row. Now I can do it but only if the row are consec.
thank you and have a wonderful day and happy new year...
|
2 |
12/27/2008 11:35:47 PM |
|
|
Help with time interval
Hi Team,
I work in a call centre and trying to write a formula
which allow me to classify calls received / abandoned between 30
minute intervals .
Time abandoned No of calls Time
9:00:00 am 1 This is where I need the formula (output
should say 9:00-9:30 am
9:08:00 am 1 output should say 9:00-9:30 am
9:10:00 am 1 ...
|
8 |
12/27/2008 9:35:11 PM |
|
|
Need help with formula
This may have gotten posted twice and I apologize if it did.
I have racked my brain to try and figure this out. I have a worksheet with
the following I am having trouble with the ROUNDDOWN part of formula in
Columna J.
Col E: Monthly Pmt
Col G: Total to be paid back
Col H: Amt Pd so far
=IF(TODAY()<=R30,MIN(G30,E30*J30),MIN(G30,E30*J30))
Col I: Balance
=IF(H...
|
2 |
12/27/2008 8:10:14 PM |
|
|
Table Lookup
I have a table:
Title Prod1 Prod2 Prod3
Rep $1 $2 $3
SRep $4 $5 $6
Mgr $7 $8 $9
If SRep sells Prod3 I want to be able to cross reference and return $6.
The table for me to search is static. The information that will change is
the salesperson's title & what product. How can I traverse this matrix other
than VLookup?
Thanks Much...
|
5 |
12/27/2008 5:47:01 PM |
|
|
Need help with formula
I have racked my brain to try and figure this out. I have a worksheet with
the following I am having trouble with the ROUNDDOWN part of formula in
Columna J.
Col E: Monthly Pmt
Col G: Total to be paid back
Col H: Amt Pd so far
=IF(TODAY()<=R30,MIN(G30,E30*J30),MIN(G30,E30*J30))
Col I: Balance
=IF(H30="","",G30-H30)
Col J: Pmts made
=IF(TODAY()<$...
|
3 |
12/27/2008 5:38:37 PM |
|
|
Air Rift Air Rift man Air Rift women ( paypal payment )( www.king-trade.cn )
Timberland Timberland man Timberland women
( paypal payment )( www.king-trade.cn )converse converse man converse
High man converse women converse High women
D&G D&G man D&G women
ARMANI ARMANI man ( paypal payment )( www.king-trade.cn )
CHANEL CHANEL women
Lacoste Lacoste man Lacoste women
( paypal payment )( www.king-trade.cn )HOGAN HOGAN man
Dior Dior women
CK CK women
EVISU EVISU man...
|
1 |
12/27/2008 7:30:13 AM |
|
|
How do I test a cell's formula (ex: Is this cell and Avg or a sum?
I want to be able to test the formula for a cell to see if it is an Average
or a Sum.
EX: ( if the first 4 characters of the forumula for A:3 = "=AVG", then B:3 =
"Average")
If not, can I designate cells by color. Then test for all cells that are a
certain color...
EX: (if Color of A:3 is red, then B:3 equals "Average")
...
|
2 |
12/26/2008 9:54:42 PM |
|
|
Need Formula for Calculating Accrued Vacation Time
Using Excel 2003. i have hire date and today(). i have a formula that
calculates time employed in years, months, days. i need a formula that
can help me figure out the number to vacation days accrued starting on
1/1/09. Policy: after 1 year of service = 5 days or 40 hours. after 2
years of service = 10 days or 80 hours. after 8 years of service = 15
days or 120 hours. Accrual is based on h...
|
3 |
12/26/2008 8:28:53 PM |
|
|
Other users are freezing without knowing it??
Several users on a network Excel file freeze rows in the worksheet. They are
not savy enough to know how to do it intentionally and the places it ends up
frozen is very haphazard. Can I lock the freeze that should be maintained?
And, can freeze be done any other way than the drop-down menu?...
|
2 |
12/26/2008 8:11:48 PM |
|
|
Count using multiiple Criteria
I am trying to count the number of time a text srting appers. But, only if
it meets two other criterias. For Example I have three columb a is rank,
columb B is Gender and columb c is building. I want to count the number of
times a particular rank appears in columb a but only if the gender is Male
and the building is 2071.
Can any one help me? By the way I need to do this in Excel 20...
|
10 |
12/26/2008 6:54:17 PM |
|
|
networkdays function
I need to set the weekend days to Friday & Saturday instead of Saturday &
Sunday in Excel. ...
|
5 |
12/26/2008 6:08:55 PM |
|
|
How to Lock sort on a data entry sheet.
I use a worksheet “Order Entry†to enter new sales order information (a row
for each order). Data is entered in columns A-F. This is a source worksheet
that is linked to a destination sheet in several other workbooks used for
pricing and commissions. Data is entered in the Pricing / Commission sheets
in columns G-L. I want to be able to lock down or protect the Order Entry
source s...
|
2 |
12/26/2008 4:34:09 PM |
|
|
How to - sort a protected sheet?
I have a sheet where all the cells are linked to a source sheet. I want to
allow sorting, filtering and pivot tables, but no changes / edits to the
cells. I tried the “Protect†the sheet and checked the boxes to allow all
users to Sort, Filter and use Pivot tables but, when I turn on the protection
and try to sort I get and error “The command could not be completed by using
the r...
|
1 |
12/26/2008 4:34:00 PM |
|
|
Formula for Updating Several Worksheets at One Time
When I update my master worksheet, I want to save time by updating several
tabs at the same time.
I am using the following formula/function:
=VLOOKUP("BOS",Master!A$3:B$26,2,FALSE)
I have several dealers within the BOS region. I want in column A (BOS
"region"), column B (dealer code), column c (dealer name), etc. The above
function is pulling over the Region, but not separating the...
|
5 |
12/26/2008 3:49:00 PM |
|
|
formula required
Hi,
I have a data in column A for 800 lines.
Column A Column B Column C Column D Column E
123 3 123-002 123-003 123-004
432 2 432-002 432-003
As defined above, the data what I have in Column A should be counted the
number of times in Column B and it has to repeated so many times in different
columns with t...
|
9 |
12/26/2008 10:54:41 AM |
|
|
Internships, part time jobs, and fresher jobs for students on SearchMyCampus.com
Upload your resume on searchmycampus.com to get part time jobs,
internships, graduate jobs, volunteer work, freelance work and more.
Click on the link given below or visit www.searchmycampus.com to
upload your resume today.
Past employers listed on the website include UTV, Reliance, Bharti
AXA, Pankhudi Foundation, Deepalaya, Subway, and KFC
http://www.searchmycampus.com/resume_landing.p...
|
1 |
12/26/2008 10:16:48 AM |
|
|
Dsum formula interpretation
Can someone interptert the following formula for me?
=DSUM(rec_db,"9" CRITERIA!$C$1:$C$2-DSUM(exp_db,,"9",CRITERIA!$C$1:$C$2). I
am not very knowledegable about formulas, I recognise the range and absolute
arguments only. This formula is in a workbook I am amending. I need to
understand its function to amend it....
|
3 |
12/27/2008 5:56:21 PM |
|
|
Subtotal withouth subtotaling
I would like to know if there is a formula that would return subtotals from a
table. Let me explain. I have a payroll report with names of employees,
dates of payments, deductions etc. I would not want to change the order of
the table as it is updated with every week's payroll. But I'd like to
generate a report from it that'd give me year to date information, per
employee. Hope I'm not...
|
4 |
12/27/2008 6:01:15 PM |
|
|
wrong result if function values over 256
very strange behavior of if function resulting in wrong result which might be
a bug.
try it out at your own, and try other values just remember the same
difference.
a1=300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK";"NOT OK")
the result of e1 should be "OK" but its "NOT OK"
a1=200 b1=203,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK;"NOT OK")
the result of e1 is "OK" ...
|
5 |
12/27/2008 6:10:12 PM |
|
|
Work Calendar
I am a fire fighter and i only work every other day. is there a way to get
excel to color the dates that i work automaticly?...
|
3 |
12/27/2008 6:15:39 PM |
|
|
Advanced Filter using a range name as the criteria
I am running a macro and want to select records from a database that are
within a date range that the macro prompts for.
So macro gets STARTDATE and ENDDATE and has stored them in a date formatted
field.
STARTDATE=1/3/2008 and ENDATE=1/5/2008
The database is
Event Date Event Name
1/1/2008 Event 1
1/3/2008 Event 2
1/5/2008 Event 3
1/7/2008 Event 4
What is t...
|
2 |
12/27/2008 6:23:10 PM |
|
|
value shows in words
Ihave an excel sheet. and there is a column called A1= "Value" there I will
put the amount of an employee.... the next column called " Amount in words"
I need to get the value in words which I am putting on the "Value" column..
How can I get that problem solved.
Regards-
Mujeeb.
...
|
3 |
12/28/2008 9:35:20 AM |
|
|
Mirror formating changes in seperate worksheet
I'm not sure if there is a function for this, but I have two worksheets that
will having the same core structure (same column headings and rowing
headings, but different data). I want to know if there is a way that if I
add a row in the second worksheet. Any help? ...
|
2 |
12/28/2008 9:40:02 AM |
|
|
Worksheet + 1
I am working with multiple spreadsheets that contains many worksheets. These
spreadsheets are a compilation of work documents, each of the worksheets are
numbered sequentially. There is also a master spreadsheet to track all of
the multiple spreadsheets and their worksheets. The master spreadsheet has
links to each of the worksheets, but I would like to be able to do my link
one time ...
|
2 |
12/26/2008 11:11:41 AM |