I have the following formula in column "M" of the attached file
Time Card Summary - Version2.3.xlsx
The each nested if statement is on a separate line. The formula is entered as an array and is so long because of the number of possible criteria combinations, but I would like to simplify it if possible. Essentially here is the logic:
You can place an "s" in one of three columns
I would like the formula to do x if an "s" is placed in the C column, y if an "s" is found in column F, and z if an "s" is found in column I, and to add either x, y, or z if an s is found in either
There has to be a simpler way to do this.
Thanks in advance
Bookmarks