How do I create an array formula to round a number to two digits behind the decimal point, then subtract 10 from the same number? I have a number in D2 that I...

how do you enter a formula for 17.5 % v a t

Hi I am new to using Excel more interactively. I am able to create a drop down box so a user can choose a day of the week for example. But I want to be able...

how do you add a phrase to a field if the filed is blankl, also, can you have a notifiction sent to you when a date on a spreadsheet has expired?

The "group" choice is "whited out" (Dim), and does not allow me to choose this.

Hi all I am struggling to understand how to get a formula to work and have tried to read all the tips but have just confused myself more with all the...

Hi, Hope you can help. I have created a formula to fill a cell with colour based on the user input. Eg. If cell= "R" then colour cell Red; if cell = "A" then...

I am absolutely new to Excel and am having trouble interpreting the Help screens. I am learning by trial-and-error and need the most rudimentary help. For...

if i want to registar someone in sheet1 with condition of if this person in level 2 his name must appear in sheet 2 in specific schedual

I like the 2007 version and since in am not a complex user of the product I find the new look and feel of the product very well designed, but the ribbon takes...

I wrote a very simple program showing my fuel oil consumption. It seems to work ok. my problem is hiding cells that have not in use yet. Is it possible to...

i have posted on trying to get cell A1 to = a (*) based upon what ever cell B1 says. thanks thru alls help i can. but trying to figure this thing out has...

Hi ALL: I am a total newbie. I am trying to develop a worksheet that takes values from a A1 to A10 and displays a values in a B1-B10. (These A1-A10 are...

Sir/Madam, I m working with big Handicraft showroom which is mainly in business of Antique Paintings, Silver Articles, and other handicrafts items. my problem...

is it possible for a cell to be un-altered once data has been inputted? i.e. if in A1 the letter "Y" is entered then it cannot be altered unless by a nominated...

Is it possible to view two work sheets at the same time from the same workbook. I want to make changes in 'sheet1' and see the affects of these changes in...

Hi, I´m making a Worksheet to calculate the Residual Value of car at the time the worksheet is open. So i have colums with the "inicial date of the...

I have been given a data set which contains work hours and dates in the form of mm/dd/yy. I am trying to sum all the hours worked in each month. A co-worker...

On some of the excel work sheets I am using I would like to be able to insert an arrow in a cell but can't figure out how to do it. All I want is a simple Up...

I have two rows of data that contain text & numbers. I want to sort the data but the text fields must remain at the top, is this possible?