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

=IF(ISERROR(Job_Design),"X",(Job_Design))
--
Best wishes,

Jim


"Greg" wrote:


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

=IF(ISERROR(IF(Job_design,"X","")),"X",IF(Job_desi gn,"X",""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Greg" wrote in message
...

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