Solved

Nesting question

Posted on 2016-11-05
4
19 Views
Last Modified: 2016-11-06
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
0
Comment
Question by:javakit1969
  • 2
4 Comments
 
LVL 5

Expert Comment

by:C. Blaise Mitsutama
ID: 41875887
javakit1969,

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

Blaise
0
 

Author Comment

by:javakit1969
ID: 41875896
Hi Blaise
Attach file as below.
Thanks
testPH.xlsm
0
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 41875951
IF(countif(formula!$f$3:$f$25,b$5),"ph", if(weekday(b17,2),"oh",""))
0
 

Author Closing Comment

by:javakit1969
ID: 41875961
Is great !!!-thanks everyone to solve our problems.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question