How to Use IF Statement with WORKDAY function

[ExcelNoobUser]

Hi, this is a continuation of my previous question a few days ago at this thread but I created a new post as I wanted to ask something different albeit related to that thread :How to use WORKDAY to calculate the Final Training Day and exclude Weekends and Public Holidays

I want to ask how to add in an IF Statement to work with the WORKDAY function where in column H, if it is blank, the WORKDAY function would work as normal but if there is a date in the cell i.e 11-May-18, that the output in the B column will be 11-May-18 unless it is blank in which it outputs as normal from the WORKDAY function. I created an IF statement =IF(H8<>"","H8","B8") and merged with the the WORKDAY function from the previous thread, =WORKDAY(G8,300/XLOOKUP(F8,$J$8:$J$13,$K$8:$K$13),$M$8:$M$25), but for some reason it still gives the same output as before instead of taking the output in the H column if it's not blank. Is there a way I can merge the IF statement with the WORKDAY function to get it to work as intended.

 

[Fluff]

How about

=if(h8="",WORKDAY(G8,300/XLOOKUP(F8,$J$8:$J$13,$K$8:$K$13),$M$8:$M$25),h8)

 

[ExcelNoobUser]

How about

=if(h8="",WORKDAY(G8,300/XLOOKUP(F8,$J$8:$J$13,$K$8:$K$13),$M$8:$M$25),h8)

It works now, thank you, if I may ask, why does it work when the IF statement is combined with the WORKDAY function instead of separately, as I initially combined the WORKDAY function with my original IF function with an & based on what I read on ablebits.

 

[Fluff]

If the formula is in col B, then your formula will return a circular reference.

 

[ExcelNoobUser]

If the formula is in col B, then your formula will return a circular reference.

that was probably the reason why, thanks for taking the time to clarify, I was confused why using & originally didn't work

 

[Fluff]

You're welcome & thanks for the feedback.