Forum

Alien on the run
@alienontherun
Forum Home   |   Recent Posts
Active Member
Joined: Oct 16, 2021
Profile Activity
Topics: 2 / Replies: 3
AllTopicsReplies
Reply
RE: Multiple IF with AND with Networkdays.Help with the formula structure.

HI I figured out the correct way to structure the IF function. =IF(D21="New Hire",NETWORKDAYS(D22,EOMONTH(D22,0)),IF(AND(D21="LEAVER",EOMONTH(D2...

1 year ago
Forum
General Excel Questions & Answers
Reply
RE: Multiple IF with AND with Networkdays.Help with the formula structure.

Thanks. File attached. Please note that all three IFs in the formula have unique outcomes and are not interchangeable.

1 year ago
Forum
General Excel Questions & Answers
Topic
Multiple IF with AND with Networkdays.Help with the formula structure.
1 year ago
Forum
General Excel Questions & Answers
Replies: 6
Views: 103
Reply
RE: Power Query. Group Rows Based on Periods and Insert a Calculated Row. Please See Example.

Mynda, thank you for your reply. Please see sample file attached with expected outcome. Please open the second file, I can't figure out how to dele...

3 years ago
Forum
Power Query
Topic
Power Query. Group Rows Based on Periods and Insert a Calculated Row. Please See Example.
4 years ago
Forum
Power Query
Replies: 3
Views: 128