• coloring rows “if” true

    I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...

    Tstychalski5 pointsBadges:
  • Leak rate trigger

    If I have a cell that has >=50 AND another that has >=15 then I want the cell with this formula to read YES, if either of the two cells are not >= those numbers then the cell should read NO.

    Adam435 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • case when issue

    I recently came across behavior of a "case when" conditional expression that really confuses me. In this case: -- CASE when isnumeric('-10.00%') > 0 then convert(numeric, '-10.00%') end ---- the behavior is as I expected - the isnumeric() function returns 0 (cuz it ain't no number) so the "then"...

    Zhoover5 pointsBadges:
  • passing the records based on the division condtion

    a falt file containg 500 records so i need to pass the records based on the division condition to the 4 output files created i.e records divisible by 2 not by 4 means 2nd,6th,10th records must pass to file 2 and divisible by 4 pass to the file 4 and divisible by 3 passed to file 3 and remaining all...

    Satidoni5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.