How do I combine a VLOOKUP formula and a NETWORKDAYS formula?
Wonderful!!! Thank you.
"Fred Smith" wrote:
In J3, you want:
=if(g3="Defer to Network","N/A",if(g3="MTF Accept",networkdays(...),"neither
defer nor accept"))
Regards,
Fred.
"Tracy" wrote in message
...
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.
|