I need a condition to Read the excel and if the price is between $0.1 - $5 update “Action Required” as “Cheap”, if the price is between $5 - $10 update “Action Required” as “Medium price range”, if the price is > $10 update “Action Required” as “Expensive”.
Can you please share the excel file and elaborate steps to be performed on it.
If the Price is between 0.1-5 it should be update as “Cheap”
If the price is between 5-10 it should be update as “Medium Price Range”
If the price is above 10 it should be update as “Expensive”
update should be done in Action required field
Here you go.
Excel.zip (16.2 KB)
Hello @rahamtullah I’m getting the error if I’m giving that condition.
Can you please share the excel mentioned in screenshot.
amazon.xlsx (28.0 KB)
@rahamtullah I have removed $ and space using this way
Excel-Errorfree.zip (37.5 KB)
please find the error free xaml code , hope you got the solution.
issue was - 1) you were assigning one value to variable and instead of using the new assigned variable, you were using again the previous variable.
2) if u replace " " with " ." , than in case of multiple space , multiple dots(…) are assigned which is not define in any integer.
3) u handled only ($) but (-) sign is also available.
4) you can change the condition value (greater than and less than condition to other number)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.