Functions
in [Excel]
|
Adding Fractions and Displaying as a percentage. Hi, I am trying to add a number of Fractions and then display as a percentage. Does anyone know a formula that will automatically add a number of cells and display the total as a percentage? 4/4 4/4 3/3 2/2 2/2 = 100% 4/4 4/4 3/4 2/2 2/2 = ? Thanks heaps in advance. ... 29 Apr 2010 01:20
Record time by formula hi, i want to create excel sheet wherein time has to be recorded multiple time. Now() formula does not help and i don't want to use macro. Pls Suggest ... 29 Apr 2010 08:59
adding time in a work schedule adding time (30 minute lunch) to a time value (>6 hours) that is calculated from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris ... 30 Apr 2010 00:47
HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B I am trying to developt a formula that restrict symbol characters to be entred as data, help me! ... 29 Apr 2010 05:41
Which (logical) function? Table was codes...if the ID begins with a w and the number in the second column is a 1 add the ones (which are male ;) A B 1 ID Gender 2 W01 2 3 W02 1 4 G01 1 5 W08 1 I have: =COUNTIF(A$2:$A$5,"=w??")*AND(COUNTIF(B$2:$B$5,"1"))...which isn't correct because it ... 29 Apr 2010 01:20
Sorting a portion of a worksheet *Using Office 2007* I am using the sort function to organize a list by date and anniversary year. That works well. Then I insert blank lines (for readability) between groups of dates according to weeks on the calendar. No problem. Next, I want to sort the names alphabetically within the anniversary year ... 29 Apr 2010 05:41
Running calculation of a frequency Hi, On a monthly basis I need to calculate a running frequency of scores, but I'm not sure how to do it. For example, Joe receives 3 scores (based on a 1 to 10 scale) every month and I would like to track what % of those scores are 9's or 10's. I will need to track this on a cumulative basis. Jan Feb Mar 8 7... 29 Apr 2010 00:15
Reverse $String1, String2 to $String2 $String1? I've done separate functions for specific text e.g. Manager, X = X Manager Supervisor, X = X Supervisor but would love if i could just make a generic Y, X = X Y is that doable? Thanks in advance! ... 28 Apr 2010 18:37
splitting cell content from 1st column into 4 columns In my first column I have 4 cells (1-4) (5-8) etc. with general content. The content from each of these 4 cells needs to be placed in a separate column to make a list that I can sort etc. Example: COLUMN A 1 01-04-425-001 2 Heatherridge Road #301 3 Harry S... 28 Apr 2010 18:37 |