Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kdr1974

    Excel - IF AND commands

    Thanks Skipvought, will bookmark that one!
  2. kdr1974

    Excel - IF AND commands

    Many thanks - that's exactly what I wanted!
  3. kdr1974

    Excel - IF AND commands

    Hi I have a sheet which calculates a value between 0-29 based on other cells in the sheet. What I want to do is have a condition returned dependent upon the number range, for example, 0-5 returns the word "green", 6-8 returns "amber" and 9-27 returns "red". I can do this over three...
  4. kdr1974

    Macro needed for form filling and sending

    Sub MailBCST() ' ' MailBCST Macro ' Macro recorded 11/28/2008 by User ' ActiveDocument.SendMail End Sub This is all I have - sorry, I really don't understand VBA...
  5. kdr1974

    Macro needed for form filling and sending

    Hi All I have a form in Word that I wish people to complete before pressing a button which will send the completed form back to a specific email address as an attachment. I have created a macro and toolbar button which saves the form, opens new email and attaches the file but cannot get the...
  6. kdr1974

    Macro Help

    Hi All I have a form in Word that I wish people to complete before pressing a button which will send the completed form back to a specific email address as an attachment. I have created a macro and toolbar button which saves the form, opens new email and attaches the file but cannot get the...
  7. kdr1974

    Excel help needed

    Many thanks Kyle
  8. kdr1974

    Sorry, another question....

    EDIT - I have now got the scores I need by using the IF command, if there is no score I get a FALSE message (which is fine), how do I add the scores that I do have, doing a SUM always returns a nil value - is this because there is text in there as well?
  9. kdr1974

    Sorry, another question....

    Hi all I am also trying to write a questionnaire. Ideally people will put an X in one cell to indicate their preference. Each answer will then have a score. How do I SUM on the condition that one cell has an X in it and the adjacent cell has the relevant number, is it something like COUNTIF and...
  10. kdr1974

    Excel help needed

    Many thanks for help. I don't understand how to use the IF command with AND which I presume I need to since I am asking it to look at two values before producing a third, which I am also unsure of. The bold is for a bill I am separating out so I delete the bold lines to leave the amount...
  11. kdr1974

    Excel help needed

    Hi Newbie here so I hope I have the right board... Two questions... Trying to write a formula which captures risk and liklihood. What I am after is a cell to display a text value depending on whether the previous two cells contain Low, Medium or High text values. So H/H would return one...
  12. kdr1974

    Newbie - Show percentage complete as RAG Status

    Hi JBlack Thanks for this, I am using 2003. To be honest I am using Project more as a task list. As said, I can do the other bit I describe but would like to offer my manager the other option and let him pick which one he would like? Thanks in advance. Kyle
  13. kdr1974

    Newbie - Show percentage complete as RAG Status

    Hi all Newbie here. I am trying to show % complete values as graphical RAGG indicators - please could someone help? I have managed to work out how to put the circles in and also how to lift the percentage complete value - I just can't seem to apply conditions to the figure after that, i.e...

Part and Inventory Search

Back
Top