IF (OR) Formula in Excel
Link to full course: https://commercecurve.com/ultimate-ex...
Take this course if you're looking for a complete course with end-to-end Excel training to accelerate your career.
The IF function can be used to perform a logical comparison between two values by testing for a condition and returning the result based on whether that condition is TRUE or FALSE. You can also use the OR function, one of the logical functions, in combination with the IF function to determine if any conditions in a test are TRUE or FALSE.
=IF(OR(logical_test, [value_if_true], [value_if_false])
=IF(OR(logical1, [logical2], ...)
Logical_test (required): The condition you want to test.
Value_if_true (required): The value that you want returned if the result of logical_test is TRUE.
Value_if_false (optional): The value that you want returned if the result of logical_test is FALSE.