Excel Formulas FAQs

Ask an Excel Expert and Get Unstuck Fast!

Selected question asked by Excel Formulas Users

Is it possible to add up the sum of two separate columns and get those two totals in a totally separate cell?

Can I calculate percent increase of revenue from year to year?

Can I convert a number to a date? For example one has 82 days left, is there a formula that will start from today's date and give me the date in 82 days?

Can I create a formula to calculate annual rent? If rent is 2000.00 a month?

My cell contains last name, comma, first name. I need to switch it to First Name (space) Last Name

What do I typed in to get the subtraction?

I am trying to develop a formula in a cell where I can search an entire column for a particular part number. If the formula finds the number, I want a "Y" put in the cell, if it doesn't find the number, I want a "NOT FOUND" put in the cell.

I have a cell that I want to say "Yes" or "NO". If my target cell has the value 3, 4, 5 or 6 then Yes?

Taking a range of cells that contain a text "smoke" in several cells that will add into one cell with a number value ie if A1,A3,A5 have the word "SMOKE" in cell C1 would equal 3. and if A2,A4 have the word "HEAT" in cell C2 would equal 2."

I want to see a percent of a total. For instance, I make $925 per day, I want 15% to go to one thing and 10% of the original total to go to another thing, and still another 25% of original total to go to another thing. How do I set up the three columns?

I need calculate a rate of climb for an aircraft. The problem is that I have a different table for different weight. In those tables, the two variables are Temp and Altitude pressure. So depending on the weight, I need to read a specific table and then need to know the temp and Alt Px to find the rate of climb.

I need to calculate percent increase/decrease. Ex. 1 Base for year one is 345 (cell A1) the next year was 250 (cell A2). I use A1-A2/A1 and get 27.54% but it should show a negative. Ex. 2 Base year of 345(cell A1) for one year and the next year 485 (cell A2). I use A1-A2/A1 and get -40.58%, but it should be positive increase. What do I need to do to reflect a negative or positive result?

I am trying to type a formula that would calculate 80% of a specific cell. Such as 80% of 50.5. 50.5 would be in Column b, row 12. Can you help me?

Is there a simple formula that can calculate the number of months between two given dates?

I am having trouble, with a formula. When I enter the number in it show's on the box above but when I hit enter it disappears. I am so frustrated with the thing. I have tried format and choosing the number format and click ok but it does not seem to work. Also when I go to print my spreadsheet it does not print the way it looks when I preview it. What am I doing wrong?