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...
View Answer
| May 16 2008 8:17 PM GMT
| asked by
Tstychalski
Excel 2003, Conditional expressions, Microsoft Excel
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...
View Answer
| Jan 16 2008 5:32 AM GMT
| asked by
Satidoni
Conditional expressions
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" is...
View Answer
| Nov 17 2007 1:39 AM GMT
| asked by
Zhoover
Ms sqlserver, case when expression, T-SQL
