Explaining Excel Formula

[DeeDeeDee]

Hello,

Is there a program that can explain an excel formula [=IF(H19<I19,NETWORKDAYS(IF(G19>H19,G19,H19),I19)/5,0)]? I am asked to interpret (write out) the formula in Col. L. I've attached a sample of the sheet with a few rows of data.

Thanks in advance.

Regards,

[maniacb]

Have you tried using the 'Evaluate Formula' function under 'Formulas'

[protonLeah]

Always start with the inner most set of parentheses, working your way out.

[DeeDeeDee]

No, but I will look into that. Thank you for viewing.