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
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561089

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561089

Dav Wrote:
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/05?

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

Craig


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561089

craig@help Wrote:
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

Back again, sorry for confusing, just worked it out which project this
is for (=if(isnumber(a1),a1,"")format as a date), yes this does work,
however still litte problem, let me see if i can work it out 1st.

Cheers for info.

Craig


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561089

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


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561089