Dimitrios has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
IF function
How can you put a two boundary condition in a nested if function, i.e. how can someone put a < and > sign for the first check, insteda of just < or >? For example, somebody may want to iognore all values that are greater than 100 and say that the first check in the nested if function must be if Cell X is between value Y and Z then for that, if (...) do that and so on and so forth.
RE: IF function
Hello Dimitrios
Thank you for your question and welcome to the forum.
I think you would need to use an AND function as part of the logical test argument (first part) of the function. For example, if I wanted Excel to check if the value in cell X is greater than Y but also less than Z:
=if(and(X>Y),(X<Z),....
so the value in cell X would need to meet both conditions (be greater than value Y but also less than value Z) in order for Excel to then enter the 'value if true' (second part) of the function into the cell for you.
I hope this helps.
Kind regards
Amanda
