Addition of values in excel with conditions

[ppr (Peter Preuss)]

@Sonia_012
have a look below as it is similiar to your case. It is implementing a mapping function for numbers to segments:

How do I divide the given numbers into 0-10, 10-25 and 25+

@Naresh_Mandava if numbers with a + are to check e.g. 59+ we ave to parse eg. with regex \d+ and to convert e.g. Convert.toInt32(… For getting some flexibility we can work with a switch activity. Variables: [grafik] [grafik] So we define the segments within the cases similar to the defition of the arrNumbers. arrRange.Where(Function (x) iNumber >= x ).Max() calculates for us the relevant case Output of a test sequence: [grafik] find starter help here: IntNo_SegmentSwitchMapper.xaml (…