Hello, I am trying to use an IF style statement to generate a new column of results. Example: If TotalBilled is 0 then 0 else TotalBilled. I have searched quite a bit and see that IIF may be proper function but then I see other places that CASE is what I should be using. In either instance, how do I make select, run test function and generate new column header for solution?
Excel 2003 and MS query
Excel 2003 and MS query