Nesting question

hi experts,
How do I nest
IF(countif(formula!$f$3:$f$25,b$5),"ph","")
with
if(weekday(b17,2),"oh","")

PH=public holiday
OH=office hours

If weekend fault on holiday will show "oh"

thanks
javakit
javakit1969Asked:
Who is Participating?
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
IF(countif(formula!$f$3:$f$25,b$5),"ph", if(weekday(b17,2),"oh",""))
0
 
C. Blaise MitsutamaFounder/Principal | Technical Writing | Editing | Training | Design | Presentation | StartupsCommented:
javakit1969,

Can you post a file that shows example data and the current formulas?

Blaise
0
 
javakit1969Author Commented:
Hi Blaise
Attach file as below.
Thanks
testPH.xlsm
0
 
javakit1969Author Commented:
Is great !!!-thanks everyone to solve our problems.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.