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

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Dealing With Negatives

    I have a sheet containg two columns, frmatted as currency and to show negative numbers ehere approriate. e.g -£25.00 One colum shows a positive number of £3.00 (Cell A1) whilst the other shows -£1.00. (Cell D2) When I do the =SUM formula as =SUM(A1-D2) I get the result of £4.00...
    Posted to Functions and Formulas (Forum) by ian green on Sat, Aug 7 2010
  • Nested IF statement Driving Me Crazy! Please Help

    Please any1 evaluate and let me know where i am going wrong. All cells produce an OUtcome of J regardless of the amounts being evaluated. Using Excel 2007 =IF(F18<3579,"A",IF(F18<4349,"B",IF(F18<5299,"C",IF(F18<6089,"D",IF(F18<6969,"E"...
    Posted to Functions and Formulas (Forum) by Mubeen on Fri, Jul 30 2010
  • Need to generate a packing list from an order form

    Every week managers from arounfd my company send me a supply order using teh attached spreadsheet. THe main page of the sheet is setup to atuomatically calculate their order total and then we fill the order. I would like to generate a packing list to include with their order. I need the packing list...
    Posted to General (Forum) by Asher on Wed, Apr 28 2010
  • Help! Table Interpolation

    Have a table of data and I need to interpolate a value. The row names are A,B,C,D and the column names have 0.5, 0.6, 0.7, 0.8 etc. If I want to look up in that table under row B for a column value 0.67, how would I accomplish that? Any ideas!?? Thanks!
    Posted to Functions and Formulas (Forum) by Andrew Springer on Mon, Jan 11 2010
  • Average top/last 10% of a data set

    Hi I have a problem with calculating an average of top 10% of a data set. I know about conditional fromating, so basicly I need a formula which would do similar thing. I figure out how to calculate average of top ten values, but percents would do better. So, I calculate top ten values using combination...
    Posted to Functions and Formulas (Forum) by Archy on Mon, Dec 28 2009
  • Combining Two Sets of Data

    Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
    Posted to General (Forum) by rebsbails on Wed, Oct 7 2009
  • How to create a game schedule

    I am not an expert at Excel (casual use for a few years making simple reports) but I've taken on a task of creating a spreadsheet showing the game schedule for teams in our club. This spreadsheet is a tab in a workbook that keeps track of scores and stats. I'll describe the best I can. We have...
    Posted to General (Forum) by Ross Armstrong on Mon, Aug 31 2009
  • Re: excel challenge issued by my boss (help)

    To simplyfie bentleybob's suggestion you can have a look at this add-in: http://www.mrexcel.com/chal/pareto.zip All of the formulas in B are =RAND() functions. Click the checkbox to recalc, and a whole series of dynamic range names cause the chart to redisplay sorted values. It also make it possible...
    Posted to Functions and Formulas (Forum) by wendel on Mon, Aug 24 2009
  • Excel enthusiast needs expert help!

    Hello everyone, I've always found Excel to be the most flexible and easiest program to use. I'm trying to build a spreadsheet, and I need it do several specific functions. I've done a lot of experimenting, but have not got it all. I'm hoping someone here can assist me, or at the very...
    Posted to Functions and Formulas (Forum) by TexasDave on Fri, Jun 26 2009
  • Choose from list and other cells change accordingly

    Ok I have a file with 2 sheets basically. Sheet 1 is basically a database of agents with their addresses, tel, details... With this database I created a table so I can move around easily. In Sheet 2 I created a standard contract for these agents. So I basically need to create 1 contract per agents and...
    Posted to Functions and Formulas (Forum) by Antonie Polfliet on Thu, Jun 25 2009
Page 1 of 4 (32 items) 1 2 3 4 Next >
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.