[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# Nesting question

Posted on 2016-11-05
Medium Priority
28 Views
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
Question by:javakit1969
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 5

Expert Comment

ID: 41875887
javakit1969,

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

Blaise
0

Author Comment

ID: 41875896
Hi Blaise
Attach file as below.
Thanks
testPH.xlsm
0

LVL 71

Accepted Solution

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

Author Closing Comment

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

## Featured Post

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
###### Suggested Courses
Course of the Month12 days, 19 hours left to enroll