Condition to read an Excel

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”.

Hi @saikumar,

Can you please share the excel file and elaborate steps to be performed on it.

Regards,
Rahamtullah

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.
:point_down:
Excel.zip (16.2 KB)

Hello @rahamtullah I’m getting the error if I’m giving that condition.

As my excel has special characters and spaces how should I be removing them ?

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)

1 Like

@Shiva_Raj

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.