I need some help Please. not sure how to write a formula? Description of what I want.: if cell is equal to 48 or less then I want to add 3 to the cell but...

Thanks in advance to all your help. I have a formula I'm using, =(C1*3)+(E1*5)+(F1*3)+(I1*5)+K1, and I need it to repeat at the end of every row and...

Hello, I am using the following formula to extract month from the date: =month(a1) The result is 1 What I wan to see is Jan instead of 1.

This might have been asked in the past but I can not find a post about it. My question is why is it when you click a command on the ribbon; for instance:...

How can I delete multiple rows that have the same entry? Example if I filter by a certain zip code can I delete all without deleting other info?

I have the following scenario for which I would require one formula which would be in cell E25:- A numerical weight amount is input in cell A25. If the...

I've recorded a simple macro for Excel, where I work with a row. But I want to work with a row the active cell is on, but Macro Recorder has writen me an...

Hello I'm trying to add a number that was calculated by means of a formula in one column to the sum of a different column. Example: Column A ...

Finally figured out how to sort my information but this is my next question. Everything is sorted alphabetically by the first column (Name)...when I enter a...

i'm using office spreadsheet which is similar formulas to excel i believe. I want it to automatically insert a date when you open it on a certain day, i.e.,...

Hello! 1) I have two tabs, namely, Tab 1 and Tab 2 2) Tab 1 has two headings, namely, "Work Order Number" and "Total". Underneath would be a list of work...

Column A is Names, B is H for Holiday (Mental reminder column) I have column C (Monday) as a time for a person to work. IE: 09.30 - 12.00. The next column...

I am seting up a spreadsheet that works like a bank statement, So from ranges g 6 through g29 i have a balance figure. But i will be adding transactions to...

I have this equation. =Text(f1,"DDDD") Which comes out as 3/1/08 Thursday. How do I get it to come up blank till I put in a date. At the moment it comes up...

In a sum total column, how do I add more than one row at a time?

Hi, I have several reports that export into .xls spreadsheeets from SAP. They always export with multiple header lines which makes it hard to sort because...

Hi everyone. Using E02 on XP. I am trying to work some formulas and I have the general idea what I need to do. I have a date of birth and date of hire . ...

Hi, I need an alternate formula, preferably simple (I am an Excel rookie) for the following: {=SUM(IF(A19:A26"AD*", IF(A19:A26"SUB*",C19:C26,"")))} The...

Hello all I use a drop down list to allow users of a worksheet to select customer names. Is it possible to open the list and press the first letter of the...

Is there some way to show the formulas used and their current values in a report? Thanks