Nested IIF Function

[nperpill]

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?

 

[Chuck]

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?

=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
--