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

[Guest]

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

 

[Bob Phillips]

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

is all that you need

 

[Tushar Mehta]

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

 

[swatsp0p]

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

 

[Guest]

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

Craig

 

[Tushar Mehta]

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