-
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...
-
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"...
-
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...
-
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!
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...