Using IF function in spreadsheet

[jafar]

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

[Andrew]

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

[YIU WAH]

 

Hello Telerik Team,
I want to use IF function in RadGridView cell. Have you implemented this function yet?

[YIU WAH]

 

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

[Boryana]

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