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.
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 >>