In Excel how can I assign values to a Yes or No question with IF
 

I am building a spreadsheeet, where If a cell has a "Yes" in it is is work
..75 and a "no" equals 0. I know a IF statement will help, but I don't know
how.

I also want Excel to caculate from an inputted date how many moths ago it
was.


Can anyone help?


Craig

=IF(A2="Yes",.75,0)

is all that you need

--
HTH

Bob Phillips

"craigscoop" wrote in message
...
I am building a spreadsheeet, where If a cell has a "Yes" in it is is work
.75 and a "no" equals 0. I know a IF statement will help, but I don't
know
how.

I also want Excel to caculate from an inputted date how many moths ago it
was.


Can anyone help?


Craig

To answer your other question, =DATEDIF(D10,E10,"m"), where D10
contains the earlier date and E10 the later date. A very useful
function that has been in XL for several releases but remains
mysteriously undocumented. Even more mysterious is that it was
documented in 2000 help and the documentation was pulled in the next
release!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am building a spreadsheeet, where If a cell has a "Yes" in it is is work
.75 and a "no" equals 0. I know a IF statement will help, but I don't know
how.

I also want Excel to caculate from an inputted date how many moths ago it
was.


Can anyone help?


Craig

Try this (adjust cell references as needed):

=IF(A1="YES",0.75,0)

This will return zero until A1 contains "YES"

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=383652

This does answer my question to a point, but I just want it to run off todays
date, is that possible?

Craig

"Tushar Mehta" wrote:

To answer your other question, =DATEDIF(D10,E10,"m"), where D10
contains the earlier date and E10 the later date. A very useful
function that has been in XL for several releases but remains
mysteriously undocumented. Even more mysterious is that it was
documented in 2000 help and the documentation was pulled in the next
release!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am building a spreadsheeet, where If a cell has a "Yes" in it is is work
.75 and a "no" equals 0. I know a IF statement will help, but I don't know
how.

I also want Excel to caculate from an inputted date how many moths ago it
was.


Can anyone help?


Craig

Well, you can always replace the appropriate argument with todays date.
To get today's date, type in 'todays date' (w/o the quotes) into XL
help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
This does answer my question to a point, but I just want it to run off todays
date, is that possible?

Craig

"Tushar Mehta" wrote:

To answer your other question, =DATEDIF(D10,E10,"m"), where D10
contains the earlier date and E10 the later date. A very useful
function that has been in XL for several releases but remains
mysteriously undocumented. Even more mysterious is that it was
documented in 2000 help and the documentation was pulled in the next
release!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am building a spreadsheeet, where If a cell has a "Yes" in it is is work
.75 and a "no" equals 0. I know a IF statement will help, but I don't know
how.

I also want Excel to caculate from an inputted date how many moths ago it
was.


Can anyone help?


Craig