Frank .S
asked on
if statement
hi experts, the following if statement is producing a "value error" and i dont understand why, could you assist?
=IF(AND(J3=$K$1,"now due",J3>$K$1,"overdue"),"" )
=IF(AND(J3=$K$1,"now due",J3>$K$1,"overdue"),""
ASKER
hi norie, thankyou and is there a way i can protect the column & hide the formula where i have this ifstatement?
ASKER
Are you using conditional formula?
If you are what options/formula are you using?
If you are what options/formula are you using?
Oops, I meant conditional formatting not conditional formula.
ASKER
i dont follow..
I was correcting a typo in previous post.
try upload a sample here?
ASKER
hi ryan chong, i have uploaded the file here for you.
protect---ifstatements_3.xlsx
protect---ifstatements_3.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=IF(J3=$K$1,"now due",IF(J3>$K$1,"overdue",