+ Reply to Thread
Results 1 to 6 of 6

language informatica (Excel 2007) or normal language for writing

  1. #1
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Question language informatica (Excel 2007) or normal language for writing

    Anybody know of any program or way to pass functions or Excel formula for writing normal??

    example:

    if 31 is greater than 29 is equal to Yes.

    IF (31> 29; "Yes," No ")
    Last edited by Birnen; 08-31-2010 at 01:30 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: language informatica (Excel 2007) or normal language for writing

    Hi, you're almost there

    =IF(31>29;"Yes";"No")

    If 31 is in cell A1 and 29 is in cell B1, then you can refer to the cells like this

    =if(A1>B1;"Yes";"No")

    cheers

  3. #3
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: language informatica (Excel 2007) or normal language for writing

    yes, that I now...

    what I won t is a program to write normaly, then the program write's the funtion...

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: language informatica (Excel 2007) or normal language for writing

    I don't think I understand what you mean. Can you spend some more time on an explanation?

    What is the input? What should the output be?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: language informatica (Excel 2007) or normal language for writing

    You can't just type a string into a cell & convert it automatically to a Formula.
    The nearest option is possibly the button marked "fx", next to the formula bar. This will open the Formula Wizard
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: language informatica (Excel 2007) or normal language for writing

    Did this solve your problem? If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1