Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The following values are taken from excel-based database, where the actual
#'s are in millions. For reporting purpose, the actual values are divided by 1,000,000 & formatted with 1 decimal (i.e. 1,230,000 = 1.2). My issue is that the total revenue is also pulled directly from the database & is not a sum. As you can see due to rounding my revenue does NOT foot down. I need to be able to tie back to database values. How can this be achieved without a lot of manual effort (i.e. adding in 0.1's everywhere). Please advice. Lease Income = 30.0 Interest Income = 3.1 Rmktg Income = 25.7 Fee Income = 2.9 Net Gain = 3.1 Other Income = 1.0 Total Revenue = 65.9 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
transfer data into row cells from column cells in Excel | Excel Discussion (Misc queries) | |||
How to import data from daily reports (excel) into excel database | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Transfer / combining Excel data | Excel Discussion (Misc queries) | |||
excel to get data from an access database | Excel Discussion (Misc queries) |