I need a formula to make a total show up in another color if it is not equal to another cell. How do I do this?

Why does Excel's DDB formula never depreciate the whole amount when the salvage value = 0? It always leaves a few hundred dollars left to depreciate -- I've...

I can not find the "list" or "create a list" command from the data dropdown menu on my toolbar. How can i find it?

I currently have a sheet that has values in D1-D10. I would not only like to show the total of those cells, but I would like the amount to appear directly...

I have this function which works. =VLOOKUP(A3,NewRev!$A$1:$B$286,2,FALSE) for A3-A500ish However, if what is in A3 doesn't return a result from the NewRev...

I need a function to remove text from a cell and leave 5 digits at the very end of the string. For example: Company One 11111 Company 2 22222 Com Three...

Here is a brief and thrown together explanation of what I want: In cell A7 I want SUM(A1:A6)IF(SUM(A1:A60) AND IF(SUM(A1:A6=0)Leave Blank In cell A8 I want...

I am looking for a way to take a list of data and transfer this to another spreadsheet, identifying who the low performers for a metric might be. The data...

I am looking for a way to take a list of data and transfer this to another spreadsheet, identifying who the low performers for a metric might be. The data...

I want to return the first date in which the sum of the previous columns first exceeds inventory on hand (total). Should return 4/5 on this...

Hello, It has been a bit since a statistics class and I cannot remember which formula(s) I should be using. What I am trying to do is this: I have data...

I am trying to execute the following formula for dates of sent/received files and I am also showing elapsed days since the files were sent....

I am an advanced excel user. I have used excel on a daily basis for over 15 years now. I work in accounting. Recently in the past year I have been an...

Here is what I have in cell A1 I have this number 22 which is convert from another cell which is 10 pm and I have tried this =A1+9 but it only returns 22:00...

I'm making a work schedule in excel but I would like to make a graph or a table showing we the employee works Here is how the data looks like: ...

What formula can I use to replace a vlookup #N/A result with a value?

Hey, I'm trying to use the IF function to create a time stamp in another cell if the Logical_Test is true. I'm kinda at a loss. If anyone could help me that...

I'm looking for a way to create a function to return the current sheet you’re working in. Not it’s name (I’ve found that function), but the number of...

I would like to have a year range in the header that looks like 2002-2003 but am unable to do it. I am using the following VB macro: Sub...

I have a spreadsheet with about a thousand lines of stock sales for the year. I need to sort by this column alphabetically by the first word after the word...