i have below query.
i am trying to total the amount mentioned in Sheet1 and out the value based on the condition mentioned in Sheet2
IF TOTAL PRICE is
then Print in Total Price
<=(Less than or equal to
>=(greater than or equal to
Work.xlsx (13.4 KB)
One simple solution would be like this:
Here is the test file:
SwirchCase.xaml (12.8 KB)
Hope this helps
Thank you however i need to total the amount first and then put the condition.
E.G. - for ABC 100+100 =200 so the condition will should appear for 200.
sorry if i had not explained properly. let me know if any queries.
Check this workflow
sample workflow.zip (2.0 MB)
Mark it as solution if it resolves your query
have a look below as it is similiar to your case. It is implementing a mapping function for numbers to segments:
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.
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:
find starter help here:
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.