Re: Function giving Error

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

I replied to your posting in the misc newsgroup. Please don't cross-post or
multi-post. The people who answer questions here ordinarily read all of the
groups.

On Fri, 30 Sep 2005 22:06:56 -0400, "Martin" <rpg_mfa@xxxxxxxxxxxx> wrote:

>Hi,
>
>I am Using Office XP and i am writing a function in Excel that is giving me
>an error "The formula you type contains an error...."
>
>here is my function
>
>=IF(B20="Semiprecious",VLOOKUP(ROUND(RAND()*100,0),semiprecious,2),IF(B20="Fancy",VLOOKUP(ROUND(RAND()*100,0),fancy,2),IF(B20="Precious",VLOOKUP(ROUND(RAND()*100,0),precious,2),IF(B20="Gems",VLOOKUP(ROUND(RAND()*100,0),gem,2),IF(B20="Jewels",VLOOKUP(ROUND(RAND()*100,0),jewel,2),IF(B20="Ornamental",VLOOKUP(ROUND(RAND()*100,0),ornamental,2)))))))
>
>
>The problem seem to be the last round(rand... function.
>If i remove the last ROUND it work fine but when i put it in i am getting
>the error. Is there a limitation with the number of function you can have in
>a single cell ?
>
>
>Any help greatly appreciated
>
>
>Martin
>
.

Relevant Pages

  • Re: Marquee effect
    ... > posting to more than one group. ... multi-post Adding the same post to more than one discussion group, ... Don't cross-post (add a single post to more than one discussion group ... To cross-post using the web-based newsreader, ...
    (microsoft.public.access.forms)
  • Re: Where in the HTML standard does it talk about a "False" return from onmouseclick canceling the a
    ... onmouseclick canceling the action of a Link Tag? ... In the comments to your other posting. ... Don't multi-post 8-(Cross-post if you have to. ...
    (alt.html)
  • Re: Windows Server 2003 / 2008
    ... See my response in the AD group to your identical posting. ... It would have been beneficial to cross-post and not multi-post to relevant groups so all postings will simultaneously be posted to ALL groups. ... Microsoft Certified Trainer ...
    (microsoft.public.windows.server.setup)
  • Re: Upgraded to 2003
    ... PLEASE DON'T MULTI-POST! ... Instead, CROSS-POST. ... That is posting the message once, to several newsgroups ...
    (microsoft.public.access.modulesdaovba)
  • Re: -2147023569 error from IIS Password Change
    ... When questions are cross-post, it unfairly ties up more of ... question can be solved by merely looking up the error code on MSDN/Google), ... This posting is provided "AS IS" with no warranties, ... As for the cross posting comment. ...
    (microsoft.public.windows.server.security)