Questions 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?