G
Greg
Hello,
I am haveing a problem using the IF(ISERROR function.
can anyone help
I am loading data with code. so i want to make it as generic as possible.
I have on 1 sheet, named cells with a checkbox in them.
on another sheet i want to put an x in a cell if the checkbox is checked.
but not ever cell will have an associated checkbox.
so I am thinking of using the IF(ISERROR function.
The basic formula is: =IF(Job_design,"X","")
Job_design being a named cell with T/F. and there are other named cells
loaded at runtime
I have tried the following
IF(ISERROR(Job_design,"X",""),"X",(Job_design,"X",""))
and
IF(ISERROR(Job_design),"X",(Job_design,"X",""))
I am trying to say, If there is a Job_design then do the formula
(Job_design,"X","").
If there is not a job_design, just put an X.
can anyone help
thanks
I am haveing a problem using the IF(ISERROR function.
can anyone help
I am loading data with code. so i want to make it as generic as possible.
I have on 1 sheet, named cells with a checkbox in them.
on another sheet i want to put an x in a cell if the checkbox is checked.
but not ever cell will have an associated checkbox.
so I am thinking of using the IF(ISERROR function.
The basic formula is: =IF(Job_design,"X","")
Job_design being a named cell with T/F. and there are other named cells
loaded at runtime
I have tried the following
IF(ISERROR(Job_design,"X",""),"X",(Job_design,"X",""))
and
IF(ISERROR(Job_design),"X",(Job_design,"X",""))
I am trying to say, If there is a Job_design then do the formula
(Job_design,"X","").
If there is not a job_design, just put an X.
can anyone help
thanks