what should be simple
b2 =min(g2,o2,w2,ae2) g2 =k2/n2 o2 =s2/v9 .... b2 works when all the cell formulas have data to compute, but does not work when one of the formulas returns the error msg #div (no data) Thanks for your help ... 26 Apr 2010 13:48
Date + relative number reference
Hi all I have a spreadsheet with dates in row 3 going from today till the end of the year i.e 26/apr/2010 In row 16 directly below the date i have a number i.e. 12 What i would like to do is: on another sheet, reference todays date i.e. 26/apr/2010 and display the number 12, but i would like this to happen... 26 Apr 2010 08:03
limit comments to only 600 words
I have created a text box but I want the text length to be equal to or less than 600 words. How do I do that in Excel 2003 please ... 26 Apr 2010 11:24
Dear, I need to calculate the below in excel sheet. please find below the details and advise me: Amount - 25000 - 3% * 3% please advise how to subtract 3% from 25000 and then calculate 3% of that amount. awaiting for your earliest response. ... 26 Apr 2010 03:42
�como puedo conbinar formulas entre hojas de exel ?
hola, sebastian ! nesecito saber si se pueden conbinar formulas entre celdas de distintas hojas de un mismo archivo no hagas preguntas al estilo de "adivinen lo que estoy pensando" (?????) por los detalles comentados (y mas bien, por los que NO expones) en tu consulta... lo mas probable es que... "quien lo sa... 25 Apr 2010 20:06
¿cómo puedo conbinar formulas entre hojas de exel ?
nesecito saber si se pueden conbinar formulas entre celdas de distintas hojas de un mismo archivo ... 25 Apr 2010 20:06
The IFERROR() Function in Excel 2007
The =IFERROR()function is brand new - introduced in Excel 2007. It is easy to use - only two arguments required. And you can display any text in the cell if the formula returns an error. Simply enclose your text in " ". Here is a link to a 4 minute video lesson that I created on this function: http://www.thecompa... 25 Apr 2010 17:51
how to sum cells and ignore the #div/0! 's ?
"Todd" wrote: I have a column of data that links to another sheet I need a ytd total for. The problem is that the cells contain formulas (on the feeding sheet) that return #div/0! until the date has passed and data is entered into its referring cells. Is there a way I can sum these columns... 24 Apr 2010 20:33
Head scratchin for hours.... Help with a formula please...
1 workbook-54 sheets. One sheet per week. On that sheet I need a way to track state mileage. 48 states. might be in a state 6 or 7 times and the all of the other states I am in then a running total for each state each week..... HELP!!!!!!! -- Bill Needham GSSComputers ... 24 Apr 2010 17:15
Drill down via page fields
I'm quite new to Pivot-Charts, so i need some help. I use a quite simple table with Employees, segments, OrderValue, Date (only months) and products. Every employee works in a bunch of segments I try to produce a line chart and filter which should show me the sum, overall, for each employee or each segment. ... 24 Apr 2010 21:39