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 totall
stuck on formulas/function that i needs.

(1)I need to 'ASK' execel to 'TYPE' "X" or "Y" on the base of what yea
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" o
"Y" will appears, how do we get the function to work only when a jo
started please?

(2)

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


TA:confused
 
Ad

Advertisements

F

Franz Verga

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:confused:

You could upload your file to www.savefile.com


--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
D

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
 
Dav said:
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 o
include an example, what is g10 what is s1? Is a jod on one line o
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 an
31/03/05?

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

Craig:rolleyes
 
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:rolleyes:

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
 
Ad

Advertisements

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:rolleyes:

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top