Using IF function in spreadsheet

5 posts, 0 answers
  1. jafar
    jafar avatar
    9 posts
    Member since:
    Feb 2013

    Posted 08 Apr 2013 Link to this post

    Hello 
    I want to use IF Function in cells. example : =-1*IF(B1>0,B8*B1,0)
    but there is an error in cells : 
         #NAME? - Invalid Name Error. 
    I think it doesn't support from IF Function.
    do you have a solution for this problem?

    thanks

  2. Andrew
    Admin
    Andrew avatar
    140 posts

    Posted 10 Apr 2013 Link to this post

    Hi jafar,

    RadSpreadsheet supports a number of different functions and we are constantly increasing that number. Unfortunately, this function is not implemented yet. We have scheduled it to be included in some of the next releases, but a specific time-frame cannot be given for the time being.

    Greetings,
    Andrew
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. DevCraft banner
  4. YIU WAH
    YIU WAH avatar
    2 posts
    Member since:
    Nov 2012

    Posted 29 Jun 2013 Link to this post

     

    Hello Telerik Team,
    I want to use IF function in RadGridView cell. Have you implemented this function yet?
  5. YIU WAH
    YIU WAH avatar
    2 posts
    Member since:
    Nov 2012

    Posted 29 Jun 2013 Link to this post

     

    Hello Telerik Team,
    Below is a small code snippet that I would like to use.

    Let us consider UnitPrice is a calculated column in the grid. It's value derived from other columns.

    IF(UnitPrice=0,100,UnitPrice)
    The objective is to replace cell value with 100 when it is 0. So UnitPrice will be displaying 100 when it
    is calculated 0.

    Any idea how do I implement this?

    Thanks,
    Yiu Wah
  6. Boryana
    Admin
    Boryana avatar
    330 posts

    Posted 02 Jul 2013 Link to this post

    Hi Yiu Wah,

    Thank you for writing.

    Before I get to the question at hand, I would like to to point out that the current thread is about RadSpreadsheet, it is not about RadGridView. In case you are using RadGridView, I kindly ask you to open a new thread in RadGridView's forum.

    RadSpreadsheet has support for the IF function since Q2 2013. The function is often used in scenarios such as yours: replacing values that go beyond a certain threshold. Note, however, that you need to include the actual computation of the UnitPrice directly in the IF statement. For example, =IF(B2*5=0, 100, B2*5). Alternatively, you can have a column that contains the raw UnitPrice and another column that holds the final UnitPrice. The latter column will contain the IF function and reference the former column.

    For your convenience I have prepared a sample project that demonstrates the second approach described above. The Getting Started article specifies all assemblies you need to run the project. I hope you will find it useful.

    Let me know if you have further queries.

    Regards,
    Boryana
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top
DevCraft banner