Validations for differnt field in excel

Ketan Patil 21 Reputation points
2021-03-01T10:09:01.297+00:00

How to validate below item

There is column in spreadsheet ParentItem Number(parent) , and Child Item (children) based on that i need to validate data

1 A validation will be displayed if the sum of the parent/children is less than 1.00 for both values for Plan fact column
2 A validation will be displayed if the sum of the effective parent/children is more than 1.00 for Roll Fact column
3 An validation will be displayed if the sum of the Parent Roll-up Factor of the e parent/children is greater than 1.00.

in c #

please have look into attached screenshot

73032-image.png

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,480 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,136 questions
0 comments No comments
{count} votes