Nested IIF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble nesting an IIF function.

My original function (which works) is:
=IIf((([#Completed]-[# Completed 1st Half])=[# Completed 2nd Half]) Or (([#
Completed]-[# Completed 1st Half])>[# Completed 2nd Half]),"Yes","No")

However I only want that function to run if:

=IIf([Reviewer]=[1st Half Reviewer], run the function above,"N/A")

any idea on how I can nest this first function into the 2nd one?
 
I am having trouble nesting an IIF function.

My original function (which works) is:
=IIf((([#Completed]-[# Completed 1st Half])=[# Completed 2nd Half]) Or (([#
Completed]-[# Completed 1st Half])>[# Completed 2nd Half]),"Yes","No")

However I only want that function to run if:

=IIf([Reviewer]=[1st Half Reviewer], run the function above,"N/A")

any idea on how I can nest this first function into the 2nd one?
Click to expand...


=IIf([Reviewer]=[1st Half Reviewer], IIf((([#Completed]-[# Completed 1st
Half])=[# Completed 2nd Half]) Or (([#Completed]-[# Completed 1st Half])>[#
Completed 2nd Half]),"Yes","No"),"N/A")

Chuck
--
 
Back
Top