formulas/function require (2)

Please bear me with this as I'm fairly new to this:-

Im currently working on a project with the excel however I'm totally stuck on formulas/function that i needs.

(1)I need to 'ASK' execel to 'TYPE' "X" or "Y" on the base of what year did a job started, e.g rewiring, central heating etc.

I have tried this:-

=if(or(g10<$a$1,g10<$a$s),"X","Y")

(a1=01/04/2005)
(b1=31/03/2005)

It will work only if a job has started, if no job star, then a "X" or "Y" will appears, how do we get the function to work only when a job started please?

(2)

There is another one that I'm stuck with, if a date has been input in a1 with =a1 in colunm b1, a date will appear but if N.W.R (no work require) or D/C (disclaimer), then N.W.R and D/C will appear in b1, is there a formulas/function that will work for only DATE, not text? Make any sense? if not, let me know i can see if i include attachment(??)


TA

craig@help wrote:
> Please bear me with this as I'm fairly new to this:-
>
> Im currently working on a project with the excel however I'm totally
> stuck on formulas/function that i needs.
>
> (1)I need to 'ASK' execel to 'TYPE' "X" or "Y" on the base of what
> year did a job started, e.g rewiring, central heating etc.
>
> I have tried this:-
>
> =if(or(g10<$a$1,g10<$a$s),"X","Y")
>
> (a1=01/04/2005)
> (b1=31/03/2005)
>
> It will work only if a job has started, if no job star, then a "X" or
> "Y" will appears, how do we get the function to work only when a job
> started please?
>
> (2)
>
> There is another one that I'm stuck with, if a date has been input in
> a1 with =a1 in colunm b1, a date will appear but if N.W.R (no work
> require) or D/C (disclaimer), then N.W.R and D/C will appear in b1, is
> there a formulas/function that will work for only DATE, not text? Make
> any sense? if not, let me know i can see if i include attachment(??)
>
>
> TA

You could upload your file to www.savefile.com


--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

you are not being very clear

what is $A$S for example

We have now idea how your spreadsheet is laidout, give us more idea or include an example, what is g10 what is s1? Is a jod on one line or over several

2) if(isnumber(a1),a1,"") format as a date

Regards

Dav

Originally Posted by Dav

you are not being very clear

what is $A$S for example

We have now idea how your spreadsheet is laidout, give us more idea or include an example, what is g10 what is s1? Is a jod on one line or over several

2) if(isnumber(a1),a1,"") format as a date

Regards

Dav

Sorry M8, my mistake with typing, $A$S should be $A$5.

G10 is where i want the result to be place at.

=if(isnumber(a1),a1,"")format as a date

this above to helps to work out between like between 01/04/05 and 31/03/06?

Do u require attachment? I'm happy to send one example.

Craig

Hi

Here the information you required, sorry can't seem to get the attachment to work but here the info below:-

(A1) 01/04/2005
(A2) 31/03/2006

(E1) 04/07/2005
(F1) 00/01/1900
(G1) 04/07/2005

(in G1 =E1+F1)
(in H1 =IF(OR(G1<A1,G1<A2),"X","Y")

If no date has been input or 00/01/1900, it will come up an "X", how do we stop this, only for when a date is input?

Hope this make sense to you?

Craig

P.S. i have other info to ask u but just wanna see if ok with u 1st