Re: Field value from Function.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try:

=indirect("M"&MONTH(A6))





"Craig & Co." wrote:
>
> Hi,
>
> I can get the value of a field from with the function
> =CONCATENATE("$M","$"&VALUE(MONTH(A6)))
>
> Result is $M$8
>
> However if I try to add this to another function
> =((B6*$B$2)/365)*CONCATENATE("$M","$"&VALUE(MONTH(A6)))
>
> I get the error #VALUE!
>
> If I type
> =((B6*$B$2)/365)*$M$8
> Then I get the correct results.
>
> I cannot find a solution in Excel Help, so I thought I'd visit the experts
>
> Cheers
> Craig.

--

Dave Peterson
.

Relevant Pages

  • Re: Field value from Function.
    ... >> I cannot find a solution in Excel Help, so I thought I'd visit the ... >> Craig. ... > Dave Peterson ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: TOO MANY DIFFRENT CELL FORMAT
    ... You can also look in the Excel Help under the topic "Specifications" ... Shane Devenshire ... "Dave Peterson" wrote: ... it always show "TOO MANY DIFFRENT CELL FORMATS" error.so this area i ...
    (microsoft.public.excel.misc)
  • Re: VLOOKUP HELP
    ... "Dave Peterson" wrote: ... Excel Help! ... But if you're just trying to determine what sheet that name is located on, ... But that will search for an exact match--just like your =vlookup() formula does. ...
    (microsoft.public.excel.misc)
  • Converting Excel 94 to new format
    ... download for it, but can't find one. ... I already have Excel Reader, ... Craig ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Keeping 2 Excel workbooks open at the same time
    ... > and somehow my settings must have gotten modified. ... Dave Peterson ... Prev by Date: ...
    (microsoft.public.excel.misc)