I have a spreadsheet to maintain truck weights.
If the weighmaster enters a Gross, and a Secondary Gross, the spreadsheet
should calculate the amount of shrink (Gross - Secondary Gross).
If the weighmaster enters ONLY a Gross and a Tare weight, the spreadsheet

Is it possible to enter multiple links in one Excel cell?  I am using the
fuction string rather than the GUI interface.
Thanks

Can I use Named Ranges in Array Formulas?  
Example here :
{=SUM(IF((ResourceName=$A28)*(ProjectID=$C28),OTLHours))}
I get the following error:  

I have a table that looks something like this:
                    100-76     51-75   26-50   0-25
$2.5m-$5m      6.02         6.65    7.28     7.28
$5m - $7m       5.47         6.03    6.59     7.17

If I have a number that I need to know if it falls between a range of two
columns and then I need to show other data if it does fall betweeen that
range what function would I use to do this
Example

... but could you explain?  I'd really like to know how this works!

I have a value (M01) in my current worksheet in F3. I want to find that value
in another workbook, match on it and return the value in column 7 of that
worksheet. I have multiple sheets in the other workbook and I am currently
looking at each one individually. The formula I am ...

I am trying to use XIRR to solve for the rate for a known schedule of dates
and value. That schedule is below. I have solved for the rate using IRR and
also a Goal Seek method to confirm the IRR. I have a spreadsheet to show all
this.

I have Excel 2000. I would like to do this without macros.
Column F is "Pace", written as mm:ss.
Column G is "Miles", written with no decimals.
Both of these columns are the result of other formulas.

In Excel 2003, I could define the Table_Array argument for the VLOOKUP
function by selecting a second workbook after the VLOOKUP argument pulldown
was activated.  I am unable to repeat this with Excel 2007... anybody know a
solution?

The following formula is working perfectly but I NOW need to add ONE more
test....
I need to check T14...if T14 is equal to the word "Forever" the result
should be "0" and there should not be any more testing ....if not "Forever"

Hy
I have to sum the values from A1:A100 if B1:B100="01-01-2006" and C1:C100="1"
With only one it works like this sumif(B1:B100;"01-01-2006"; A1:A100), but I
want some thing like this sumif(B1:B100;"01-01-2006"AND(C1:C100;"1"); A1:A100)

In trying to set up a spin button, I can't get the "Control" tab to appear
after clicking Format Control.

I need to run a vlookup for an exact value in a range and for each match
calculate the total of the cell adjacent.
For example, James appears in this list twice and I want to reach a sum of
his sales listed.

Is there a way to adjust the range in a subtotal formula to automatically
recognize the last row of data to allow for a high degree of variability in
the number of rows it contains?  I realize that I could set the subtotal
range to be, for example,  B3:B65000 -- however, users ...