The 'if' function is one of the most versatile functions in programming and therefore it is but natural that it plays an important role also in Excel macros or vba programming. Using this function you can perform many different manipulations on data based on defined condtions. So for example you can highlight a data with color if it meets a certain condition like 'greater than or equal' to 18000. In the process you would have also found a great way to do a conditional formatting. The video below describes the use of 'if' in greater detail.
|