Hi,
I have a nested if and I am trying to add an if error message and I am not getting the context right can you please help..
Basically
if there is an error in I3 return review,
If B3=nothing return nothing
if I is not greater than .01 or lessthan -.01 return review else nothing
Sample"
Column B Column C Column D Column E Column F Column G ColumnH Column I Column J Flag
Employee # Name Payroll Batch Hours Hire date Salary 1 Salary 2 Variance from G and H
7 John A
=if(ISERROR,I3,"REVIEW",IF(B3="","",IF(OR(I3>0.01,I3<-0.01),"REVIEW",""))
I have a nested if and I am trying to add an if error message and I am not getting the context right can you please help..
Basically
if there is an error in I3 return review,
If B3=nothing return nothing
if I is not greater than .01 or lessthan -.01 return review else nothing
Sample"
Column B Column C Column D Column E Column F Column G ColumnH Column I Column J Flag
Employee # Name Payroll Batch Hours Hire date Salary 1 Salary 2 Variance from G and H
7 John A
=if(ISERROR,I3,"REVIEW",IF(B3="","",IF(OR(I3>0.01,I3<-0.01),"REVIEW",""))