How do I combine a VLOOKUP formula and a NETWORKDAYS formula?

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

If cell G3 equals "Defer to Network" then I want cell J3 to equal "N/A". If
cell G3 equals "MTF Accept" then I want cell J3 to use a NETWORKDAYS formula
to calculate the difference in days. How do I combine the two formulas?
Thanks.
 
In J3, you want:

=if(g3="Defer to Network","N/A",if(g3="MTF Accept",networkdays(...),"neither
defer nor accept"))

Regards,
Fred.
 
Wonderful!!! Thank you.

Fred Smith said:
In J3, you want:

=if(g3="Defer to Network","N/A",if(g3="MTF Accept",networkdays(...),"neither
defer nor accept"))

Regards,
Fred.
Click to expand...
 
Back
Top