Usign Excel: Is there a mcro out there to retrun the ratioanl expansion of a
decimal number?
i.e., 0.75 == 3, 4

I have a complicated indirect function reference.  After about 24 sheets it
is not bringing back the correct cell value (through a vlookup).  Is there
some limit to the amount of memory required for the use of Indirects?
FYI, I have a large workbook with 60+ worksheets, and an ...

I think I used to know how to do this, but I'm on a new version of Excel
(Xl2003) so maybe that wouldn't work anyway.
I want to perform a simple COUNTIF, except the cells I want the function to
examine are not contiguous. Essentially, I need the function to be something

Based on the following example:
Item Quantity
A    2
S    7

I am looking for help with an If statement for Excel. I am trying to
build a commission calculator with a tiered payout schedule. This is
what the tiers will look like;
2% paid on all sales between $30000 and $70000

I have a spreadsheet that has in column A an account number and in column D
the another account number tied to the first.  However, the report also has
the tied account number from column D in column A and vice versa.  I need to
find the duplicate listing of accounts and remove ...

I want to input a date into column a and have it appear 90 days later in
column b in order to track due dates, etc.

does excel has a function to combine randomly a set of letters? for example:
a1:a10 contains different letters, i want to combine those letters in b1:b10
randomly. please help.
yob

I consolidate management accounts on a monthly basis. Each month's management
accounts are saved in one folder. In the following month I receive new
management accounts and I save them in a new folder. Thereafter, I copy the
consolidated management accounts from the prior month ...

Hi. could you help me multipy the value inside a cell (ex f3) x the
value I input. What would be the formula for the cell. I would like to
input the number three and have 9 come up in the cell.

How can i get the last values on next table :
DATE    KM    TYPE
16-06-2001    233.513    TIRE CHANGE
16-10-2001    281.634    VALVULINE CHANGE

I get a REF-error sometimes with the following function:
=INDIRECT(B1&"!"&C1;1)
Imagine:
in B1: Sheet1

Hello !!
I have this table :
---------------------------------------------------------------------
DATE            |        KM    |  TYPE

ok, here we go
C4:C33 is a list full of currency values. F4:F33 is full of number ranging 1
to 9.
In cell D36 i would like to add up all the values that are above the no. 8

is it possible to use an if function to change a cells color ie if B1= Sandra
then H1=Grey if not Blank