Help in "if"

Help
, ,
1

condition to determine the lowest value in an “if”?

2

Hi @borismh,

can you provide more details?

A sample is variable1 < variable2
if variable 1 is lower then it will be true else false

3

@rmunro
Hello
but I have an excel with 6 different types of suppliers
-use a “for each row” to read the excel and separate each data with “get row item”
-Then use an “if” condition to know “order volume <Volume”
-in the condition that it is fulfilled place variables to save the data
-followed in the same condition “if” place “add data row” and the “excel application scope”, so that while returning to generate data saves them in a followed way
-This way I get “costototal1”, “costototal2”, etc, until 6
-Now I want to place a message in the excel next to the cells that total cost is the lowest?
that’s my doubt is there any way to do it?
thank you

4

@rmunro

image
image1440×900 95.5 KB

here the condition “if”
image
image1440×900 105 KB

5

Ok, I kinda get it.
Why not use filter datatable to filter what you want to add instead of an if?
image

To get the min value use:
just modify it.
int minVal = (int)table.Compute("Min(ColName)", "") then just use a message box to display it.
more info here: credit to the mvp.

1 Like
6

@rmunro
int minVal = (int)table.Compute(“Min(ColName)”, “”)
In this formula, what are the words you should use:
and I also use it as? inside a “if” true

7

you just need to replace table to your datatable variable and colname with your column name you want to find the min value of your datatable.