Hi, I have created a spreadsheet but, have encountered a problem with the formula or maybe the format, not to sure. I have a workbook containing 5...

Hi, Can the following be done. I have the following formula in Sheet1 of my workbook. =VLOOKUP(B6,Sheet2!A2:BC499,5,) When cell A2 of Sheet2 is populated...

I have a problem with formulas in Excel XP: they show in formula bar AND in cells (value of formula doesn't show in the cell). I guess it treats formula as...

The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount cell)) is giving me result "num". The objective is to apply a constant inflationery...

I have been able to display & print the results (values) of the formulas that I have developed, but what I really need is to be able to display & print the...

I have two cells that are set for h:mm and the time will switch throughout a 24 hour time period. For some reason ever fix I have tried, the time is still...

Can anyone help me with working out a formula which automatically rounds data up or down? I am developing an assessment data base for my school and need...

i want to check multiple cells with something like: IF CellA=1 AND IF CellB=CellC,1

I have a schedule for 50 people with names in a column A and days of the week in first row: each employee can be assigned to one of four duty stations, be off,...

I went into the VB editor, created a new module, wrote a buncha functions, and when I go to use them in my spreadsheet I get #NAME?. When I type in the...

Hi, i format all cells in D,E,F and G to currency and try to typ for example 1459.70 in cell D but it returns just this ########. Can someone tell me why...

Hi, I would realy appreciate if someone can help. Here is my question, 1) Is there a function if i type in a cell for example 500£ that it will be...

Hi there, i just started to use Exel 2003 and would realy appreciate if someone can help. Here are my two questions, 1) Is there a function if i type in a cell...

I am new in Excel 2007. In Excel 97' there was an option or using special graphs which allowed you to have dual Y-Axis. You could then graph both $ and %...

How do I Count a Range of whole-numbers / integers only?

HOW DO I INPUT FEET AND INCHES AND CALCULATE WITH THEM (I.E. +/-)

I have a list of phone numbers, some of the numbers have multiple numbers associated with them, some do not. When I autofilter, I see all the numbers I...

Hello: I do not know if this is the corrrect group for this question but here it goes. I can add items to a Combo Box either via the Box properties or in...

Hi all, I have 3 different sheets with 3 different time frame (Daily, Hour, 5 Minutes). I would need a formula that would allow me to look for a set time (5PM)...