This is a migrated thread and some comments may be shown as answers.

Logical operators

1 Answer 70 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Adrian
Top achievements
Rank 1
Adrian asked on 25 Oct 2016, 10:38 AM
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

Sort by
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.
Tags
Spreadsheet
Asked by
Adrian
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or