Conditional Expressions

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.

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

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

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

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