Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Formulae (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Excel 2007 and 2010 forum. See all tags in the site
  • What VLOOKUP & SUM formula would I use ?

    Hi I have two worksheets. One listing all days against a individual contract e.g. Contracts Days 1234 1 1234 4 1234 2 1234 9 1235 1 1235 6 1235 0 1235 11 1236 7 1236 2 1236 20 1237 1 1237 7 1237 5 1237 5 and the other where I want to look this days total up for that contract e.g. Contract Total days...
    Posted to Excel 2007 and 2010 (Forum) by George3578 on Fri, Sep 5 2014
  • Multiple IF condition formula

    Can we use multiple if condition to check the looped info for 12 times or more. I was trying to get the billing info on monthly basis and try to find the info on month input by putting vlookup condition.. the worksheet as as below customer code name april may june july aug sep opeing clossing opeing...
    Posted to Excel 2007 and 2010 (Forum) by arvinder on Sat, Jul 6 2013
  • Find the difference for the value and revert with the three values

    Hi Everyone, I have to write a formula in Excel for the below requirement 0 mins - 30 mins = 10 rs 30mins - 1 hour = 20rs 1 hour - 1hour 30mins = 30 1 hour 30 mins - 2 hours = 40 The time will be increment in half hr and the amount will be increase in 10 rs... if its possible to claculate for 15 mins...
    Posted to Excel 2007 and 2010 (Forum) by karthi024 on Mon, Aug 1 2011
  • Inconsistent Row Insertion and Forumla Errors

    I have created a workbook with several tables. Each table has summation columns at the bottom, as well as formulae that operate internally within each row. I am trying to insert new rows at the bottom of each table, but before the bottom summation row. I would like this row to include the formulae from...
    Posted to Excel 2007 and 2010 (Forum) by adam888 on Fri, Nov 5 2010
  • Re: "Use in Formula" feature for a named range in 2007

    Angela I've not used this before but it works for me. I defined a named range and then activated the 'Insert Function' funcionality from the formulas tab. That fires up a wizard with the various parameters needed for a VLOOKUP and if I click in a refedit box (The ones you can select cells...
    Posted to Excel 2007 and 2010 (Forum) by Nick Hodge on Fri, Feb 29 2008
Page 1 of 1 (5 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.