REENA GUPTA
Member
Hi
I have to calculate "due by time" . Due by time is different based on the combination of priority(HIGH/MEDIUM/NORMAL) & Region (CO/NR/WR/ER) . Conditional matrix is shown in the attached sheet . I am using office 2007. I am totally confused . Please help me how to write this nested if condition .. .
kindly advise me if there is any other way to calculate due by time.
Thanks in advance
I have to calculate "due by time" . Due by time is different based on the combination of priority(HIGH/MEDIUM/NORMAL) & Region (CO/NR/WR/ER) . Conditional matrix is shown in the attached sheet . I am using office 2007. I am totally confused . Please help me how to write this nested if condition .. .
kindly advise me if there is any other way to calculate due by time.
Thanks in advance