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. abzurd

    Conditional statement emailing in Excel (w/ a twist)

    Thanks, Zathras (and you too xlbo - that link that shows circular references being useful is pretty cool) We unaware of the Worksheet_Calculate() function. We implemented this logic into our solution and got it working. Thanks again :-)
  2. abzurd

    Conditional statement emailing in Excel (w/ a twist)

    I'm not sure how there is no circular reference in your example. The function seems to still be referring to a value that is written in the same cell as the function. This is the current formula: =IF(H5<=0,SendEmail(ROW()),&quot;&quot;) H5= the variance that changes constantly via the DDE...
  3. abzurd

    Conditional statement emailing in Excel (w/ a twist)

    &quot;What does the function return then ??&quot; - The function returns &quot;email sent&quot; &quot;eg in D2 =IF(C2=1,1,0) Within the function you can check for the value of the adjacent cell&quot; - If the function checks for the value of D2, which is referring to C2, you have created a...
  4. abzurd

    Conditional statement emailing in Excel (w/ a twist)

    Thanks for the replies. The problem is an excel function can write value ONLY to the cell which was called from, excel won't let a User Defined function to change anything but the value of the cell which called the function. In macros we can do anything but you cannot run a macro continuously(my...
  5. abzurd

    Conditional statement emailing in Excel (w/ a twist)

    In one column is the target price. In another column is the DDE link with the current price. The DDE link changes constantly. There is a third column that has the variance between the two prices. The current macro function checks this variance column. When the variance crosses 0, meaning the...
  6. abzurd

    Conditional statement emailing in Excel (w/ a twist)

    I have a spreadsheet that has DDE links to a live NYMEX (New York Merchantile Exchange)feed that has pricing for natural gas. In the spreadsheet I enter customers and the prices they would like to buy their gas. When that price is met we want an email to be sent to whomever we choose that alerts...

Part and Inventory Search

Back
Top