I am trying to produce a formula as to where I key in a specific letter and the cell will turn to a specific color. for example: if I type in the Letter "A"...

Choose an Ferrari car model below to view comprehensive car pricing, current rebates and incentives, safety data, & more. The Ferrari 599 GTB Fiorano Sets a...

My first of many complaints. I was trying to customize the paper size in Excel. The steps I took: (1) Page Setup (2) Options (3) Paper Quality (4)...

I need to total A1:A3 in A4 with a not to exceed value such as if sum is greater then X, then X. Thanks

I have a monthly time sheet on which I post hours for a number of different projects. On Sheet 1 the columns from left to right are Date, Project, Activity,...

I have two data source columns named Service (J1) and FCP (K1). Service column is text data and FCP is number data like this: Service FCP AMMS ...

Can you convert a worksheet with multiple columns and multiple rows of data into 1 column? CURRENT WORKSHEET STRUCTURE(assume A1=_-Insert,...

When calling a user defined function on a worksheet its not found unless I enter the full path ex) PersonalXL.labor (X,Y,Z). How can I eliminate the need to...

I have a formula in a workbook. When the sheet that I am getting the updates from are in the same workbook it works great and it updates immediately when I...

There are a number of formulas that have ^ in them. What does the ^ operator mean?? i.e. $Z$4^2

I have 76 workbooks with multiple worksheets within. For two of these worksheets, I need to combine the values of all the cells into a new...

I have a spreadsheet listing registered customers for a rewards card. it includes customer id numbers, addresses and date of last use. the issue is that there...

Hi I have a total of debits and I also have some credits. What formula do I use in order to have excel add the debits but not subtract the credits which...

in Excel 2003 I have a formula =MIN (100, A1) If A1 is blank it returns 100 but if A1=0 then it returns 0. Why doesn't it see the blank as a 0? Is there...

How would I set up a Time format that every time I insert the Time hh:mm:ss,It will not update automatically example: =NOW() ?

I DEVELOP A MODEL, I NEED TO TAKE A DATE AND CONVERT IT IN QUARTER

I have the following formula in my spreadsheet =IF(SUMPRODUCT(MAX(($C$2:$C$100)*($A$2:$A$100=A2)))=C2,C2,"") The formula works great - however when I paste...

Hi All, Ok, I can't think of any remotely-easy way to do this. My data exists as such: accounts listed in the rows, dates (by month) listed in the columns;...

Hi am trying to calculate variances in a spreadsheet and am running across a problem with the formula returning the wrong value for the cell, for instance...

I want to apply conditional formatting to cell B4 or the range of cells as yellow highlighted when the value of cell A1="Y" I have tried formula is...