Functions

Rounding Up question
Hi, A1 has the ROUNDUP Function referenced to B1: ROUNDUP(B1,0). Example: B1 says: 6.2 A1 will roundup to 7. Perfect! This works 99% of the time. But in a special case B1 says 6.0 - A1 still rounds up to 7. I expanded B1 decimal places and found B1 in this case really says: 6.00044. Hence the reason f... 15 Apr 2010 12:32

rounded # to correct #
I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I use to get the real number which is 12.85? Please Help! ... 15 Apr 2010 15:53

creating a report from a table, pivot table not suitable
hi I have data table with 7 headings, the cell of each row contains a project code and there are multipule project codes. By means of a drop down list (list of the project codes) I wish to be able to create adhoc pre-formatted MIS reports that show only the details of the rows for the selected project code.... 16 Apr 2010 04:01

Pivot table show all days of a month even if no data
Hello, My question is the following. If i have data based on date (days). How to show all the days of the month even if there is no data for some days in the month ? I have a hole in pivot table ! Thank you in advance for your help. ... 15 Apr 2010 22:35

VLOOKUP & IF
Hi All, I am looking to use an if statement with 2 separate vlookups. Is this possible? Basically what I want to do is if B3=PWRFUT then lookup(A3,'FUT'!A1:C20,2) However, if B3 does not equal PWRFUT then lookup(A3,'FX'!A1:C20,2) Please help - thanks ... 15 Apr 2010 19:15

Convert percentage into margin
Here is my quandry and I am probably over thinking it. I have a starting cost of $26.00 with an end cost of $26.54. I need to know the formula that will show the margin. If I divide $26.54 by $26 I end up with 1.021 but I can't create the formula to remove the leading 1 to get to the margin of 2.1%. Thanks fo... 15 Apr 2010 11:24

pounds shillings pence format in excel
I want to use pounds shillings and pence format in excel...is it possible and if so how do I go about it? ... 15 Apr 2010 12:32

Help with If Sum statement - i think....
Hi, I need to be able to do the following but i can not quite arrange the formula corectly.... I have one sheet that has all the weeks in coulumns (for a project). In another sheet i have this A B C D E Analysis Task 3 12/04/2010 14/04/2010 Task 5 15/04/2010 21/04/2010 Task 3 22/04/... 15 Apr 2010 12:32

Can I combine a Vlookup with an IF formula?
I'm not sure Excel can do what I want it to do - I have a VLookup formula on my spreadsheet which is returning data, however, I only want it displayed if it returns a specific condition. Is this possible ? -- CMB BT ... 15 Apr 2010 09:11

Setting up an electrical register in Excel with expiry dates
I am currently setting up an electrical register using Excel 2003 which shows a date column of when the equipment has to be retested. I would like to have the date columns in green, then two weeks before the expiry date, have them change to yellow. Once the date has expired, I would then like the column to c... 15 Apr 2010 06:58