how do I write a formula to pick a date or N/A?

[Scott]

I am using a spreadsheet to show when required tasks are due for specific
classes. My problem is this: when a class does not go through a specific
portion, I put N/A in the date block for that portion, and would like it to
put N/A in the specific date blocks for the specific tasks, not the date the
task is due. So what I am getting is "#value!".

Thanks
Scott

[CLR]

Please post your formula that is causing the "#Value!" error and someone will
help....

Vaya con Dios,
Chuck, CABGx3



"Scott" wrote:

> I am using a spreadsheet to show when required tasks are due for specific
> classes. My problem is this: when a class does not go through a specific
> portion, I put N/A in the date block for that portion, and would like it to
> put N/A in the specific date blocks for the specific tasks, not the date the
> task is due. So what I am getting is "#value!".
>
> Thanks
> Scott

[David Billigmeier]

=IF(A1="N/A","N/A",your_formula)

--
Regards,
Dave


"Scott" wrote:

> I am using a spreadsheet to show when required tasks are due for specific
> classes. My problem is this: when a class does not go through a specific
> portion, I put N/A in the date block for that portion, and would like it to
> put N/A in the specific date blocks for the specific tasks, not the date the
> task is due. So what I am getting is "#value!".
>
> Thanks
> Scott

[Scott]

Thanks David,
Sorry but I am still a little lost, in my spreadsheet I have a list of
tasks that need to be done at specific times (i.e. 45 days from start of
class, 15 days after completion of this class...) at the top of the
spreadsheet I have the dates of when certain portions begin to figure out the
task dates (=k6-45...) but sometimes I need to put N/A (Not Applicable) in
those date blocks if that class is not being taught. So if I do that, what I
would like it to do is to also put N/A in the specific tasks assigned to that
class. Does that make sense?

Scott

"David Billigmeier" wrote:

> =IF(A1="N/A","N/A",your_formula)
>
> --
> Regards,
> Dave
>
>
> "Scott" wrote:
>
> > I am using a spreadsheet to show when required tasks are due for specific
> > classes. My problem is this: when a class does not go through a specific
> > portion, I put N/A in the date block for that portion, and would like it to
> > put N/A in the specific date blocks for the specific tasks, not the date the
> > task is due. So what I am getting is "#value!".
> >
> > Thanks
> > Scott

[CLR]

Instead of just =K6-45, use this......

=IF(K6="N/A","N/A",K6-45)

Vaya con Dios,
Chuck, CABGx3


"Scott" wrote:

> Thanks David,
> Sorry but I am still a little lost, in my spreadsheet I have a list of
> tasks that need to be done at specific times (i.e. 45 days from start of
> class, 15 days after completion of this class...) at the top of the
> spreadsheet I have the dates of when certain portions begin to figure out the
> task dates (=k6-45...) but sometimes I need to put N/A (Not Applicable) in
> those date blocks if that class is not being taught. So if I do that, what I
> would like it to do is to also put N/A in the specific tasks assigned to that
> class. Does that make sense?
>
> Scott
>
> "David Billigmeier" wrote:
>
> > =IF(A1="N/A","N/A",your_formula)
> >
> > --
> > Regards,
> > Dave
> >
> >
> > "Scott" wrote:
> >
> > > I am using a spreadsheet to show when required tasks are due for specific
> > > classes. My problem is this: when a class does not go through a specific
> > > portion, I put N/A in the date block for that portion, and would like it to
> > > put N/A in the specific date blocks for the specific tasks, not the date the
> > > task is due. So what I am getting is "#value!".
> > >
> > > Thanks
> > > Scott

[Scott]

Worked great, thank you!

"CLR" wrote:

> Instead of just =K6-45, use this......
>
> =IF(K6="N/A","N/A",K6-45)
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Scott" wrote:
>
> > Thanks David,
> > Sorry but I am still a little lost, in my spreadsheet I have a list of
> > tasks that need to be done at specific times (i.e. 45 days from start of
> > class, 15 days after completion of this class...) at the top of the
> > spreadsheet I have the dates of when certain portions begin to figure out the
> > task dates (=k6-45...) but sometimes I need to put N/A (Not Applicable) in
> > those date blocks if that class is not being taught. So if I do that, what I
> > would like it to do is to also put N/A in the specific tasks assigned to that
> > class. Does that make sense?
> >
> > Scott
> >
> > "David Billigmeier" wrote:
> >
> > > =IF(A1="N/A","N/A",your_formula)
> > >
> > > --
> > > Regards,
> > > Dave
> > >
> > >
> > > "Scott" wrote:
> > >
> > > > I am using a spreadsheet to show when required tasks are due for specific
> > > > classes. My problem is this: when a class does not go through a specific
> > > > portion, I put N/A in the date block for that portion, and would like it to
> > > > put N/A in the specific date blocks for the specific tasks, not the date the
> > > > task is due. So what I am getting is "#value!".
> > > >
> > > > Thanks
> > > > Scott

[Scott]

Worked great, thank you!

"CLR" wrote:

> Instead of just =K6-45, use this......
>
> =IF(K6="N/A","N/A",K6-45)
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Scott" wrote:
>
> > Thanks David,
> > Sorry but I am still a little lost, in my spreadsheet I have a list of
> > tasks that need to be done at specific times (i.e. 45 days from start of
> > class, 15 days after completion of this class...) at the top of the
> > spreadsheet I have the dates of when certain portions begin to figure out the
> > task dates (=k6-45...) but sometimes I need to put N/A (Not Applicable) in
> > those date blocks if that class is not being taught. So if I do that, what I
> > would like it to do is to also put N/A in the specific tasks assigned to that
> > class. Does that make sense?
> >
> > Scott
> >
> > "David Billigmeier" wrote:
> >
> > > =IF(A1="N/A","N/A",your_formula)
> > >
> > > --
> > > Regards,
> > > Dave
> > >
> > >
> > > "Scott" wrote:
> > >
> > > > I am using a spreadsheet to show when required tasks are due for specific
> > > > classes. My problem is this: when a class does not go through a specific
> > > > portion, I put N/A in the date block for that portion, and would like it to
> > > > put N/A in the specific date blocks for the specific tasks, not the date the
> > > > task is due. So what I am getting is "#value!".
> > > >
> > > > Thanks
> > > > Scott