Boys !!! I always ask for your precious help !!!
I have three columns “AP First” and “Ap Last” and “Result”. I would like with a formula that if “AP First” is greater than the value of the “FIRST ACT” column in the Result column it would write “out of range” otherwise if false “in range”
I hope I have explained
Thank you
Solved! Go to Solution.
There is some confusion here. You mention an “AP Last” column but don’t include that in your expression description.
If I were to write and expression based on exactly what you have said, it would be like this:
IF([AP First] > [First Act], "Out of Range", "In Range")
This expression would be inserted into the [Result] column either as an “Initial Value” or in the “App Formula”…depending on your needs for the column.
There is some confusion here. You mention an “AP Last” column but don’t include that in your expression description.
If I were to write and expression based on exactly what you have said, it would be like this:
IF([AP First] > [First Act], "Out of Range", "In Range")
This expression would be inserted into the [Result] column either as an “Initial Value” or in the “App Formula”…depending on your needs for the column.
Perfect works greats Thanks a lot!!!
User | Count |
---|---|
43 | |
27 | |
23 | |
16 | |
12 |