Is there any way to use logical operators like AND or OR in formula? Stacking IFs is rather inconvinient in larger formulas.
1 Answer, 1 is accepted
0
Veselin Tsvetanov
Telerik team
answered on 27 Oct 2016, 08:22 AM
Hello Adrian,
Similarly to Excel, the Kendo Spreadsheet allows you using AND and OR logical operators. For example, you could test the following formula on our demo page: =AND(A16>A17, A16<A18)
Regards,
Veselin Tsvetanov
Telerik by Progress
Check out the new UI for ASP.NET Core, the most complete UI suite for ASP.NET Core development on the market, with 60+ tried-and-tested widgets, based on Kendo UI.