Hello, I have an excell spread sheet. In this spread sheet i have 3 columns-
column1=START DATE column2=hidden number field column3=GOAL DATE
I am trying to write a formula for each GOAL Da...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/01/2005 Grade: A Views: 0
Simple math here, but I stink at math:
Paycheck = $500
Bills that week = $320
I need a forumla that will tell me what percentage of payckeck is SPENT and is LEFT?
Ugh..
Thanks
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/15/2006 Grade: A Views: 0
i have this formula
=(IF(D4=0,,CONCATENATE(C4," ", D4)))
which currently displays
down -0.22222626544523
i want it to say
down -22%
can it be done
D4 is the value and C4 is...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 08/24/2006 Grade: A Views: 0
Hi,
I have which has below formulas which sums up talk minutes by Service Provider grouped by Country wise {s_CDR.Country}:
Group Header 1# {s_CDR.Country} A
1) Forumla=WT2-Term
{s_CDR...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_21974078.html
I am trying to write a "IF" forumla to add up bonus.
The forumla will be in cell B8 so if a number in C8 is 230 then B8 will be 100.
If someone gets 224 than zero
If beween 225 and 274 then th...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/31/2007 Grade: A Views: 0
I have the following macro:
-------------------------------------------------
Sub Workbook_Open()
Dim rg As Range, rgHighlight As Range
Dim X As Variant
Dim i As Long
Application.ScreenUp...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 03/23/2004 Grade: A Views: 0
I have a workbook with multiple worksheets. Each sheet is a detailed page with dates and times. Sheet 1 has been added as a quick view of each page. The rows of Sheet 1, column A has the name of ea...
http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_23486024.html
I have a table of contents sheet which includes the tab names of all the sheets in the Excel workbook. Is there a formula that I can use in the cells to show the value (name) of the tab names. So...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/02/2005 Grade: A Views: 0
This is probably simple for you Excel gurus....but I haven't a clue.
Let's say I have a column.....
347
312
163
430
640
227
325
244
328
274
169
77
136
0
254
313
200
=======...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
i have a time report i need to do, and i need to round all time up to the nearest 6 seconds.
however i am horrible at forumla's and unable to find anything online
any help would be greatly ap...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
