I was hoping someone with some computing knowledge might be able to help me? I’m using a report generator in a project accounting package called “Causeway Project Accounting”, which might seem old fashioned, as there is supposed to be a method of exporting the report directly into Excel in order to use the increased functionality that is deemed to offer. However, although we technically are paying the license fee for access to that service, we don’t actually have access due to some other political reason or other which I shan’t even bother going into! You might also suggest just cutting and pasting the report into excel then using the “text – to – columns” feature to then apply the formula required – technically possible, but that then entails a lot of tidying up, deleting superfluous title rows which have exported from the original report etc. Right, that’s the background over with: The Problem: Let’s say I have produced a report which looks like this: Code Value H00128 3710.74 H00801 999.10 H00988 3923.79 Within the report generator I can set calculations, which should return values accordingly. For example, I want to apply the rule that for every value below 1000, 10% is added. The calculation (extension) would look like this: (C2<1000) *C2*1.10 i.e. If a value column 2 is below 1000, multiply the existing value by 1.10, which will add 10% to the value. I then have to tell the report where to print the new result, so let’s put that in column 3 and call it ‘+%’. Code Value +% H00128 3710.74 0.00 H00808 999.10 1099.01 H00984 3923.79 0.00 That’s okay, but I want to apply the rule that say, for values over 1000 I want to add 50%. I can easily add a new column, and apply the formula similarly to the last 1 e.g. (C2>1000) *C2*1.50. What I really want to do is to print all the results in one column, which I think is when I need to use a ternary expression, but everything I try fails! I’ve got the manual out, which has one tiny section on Report Calculations in it: “When defining ‘extensions’ or ‘exclusions’ within the column definitions for reports, a calculation syntax is available which allows column numbers to be acted on by mathematical and logical operators. For example, an extension may be: C1*100/C2 (show column 1 as a percentage of column 2). The available operators are: + (add) * (multiply) % (modulo) < (less than) <=(less than or equal to) !=(not equal to) ||(logical OR) ?: Ternary expression (see below) - (subtract) / (divide) > (greater than) >= (greater than or equal to) ==(equal to) && (logical AND) !(negate) The logical operators would be used for an exclusion test: for example, C1==0 ||(C5==0 &&C6==0) would not print the line if column 1 was zero, or both columns 5 and 6 were zero. Note the use of brackets to combine expressions in order to force the correct precedence. The ternary expression listed above can be used to return a value depending on the result of a test. For example, within an extension column: (C1!=0)?C2*C3:C4*C3 which states: print the product of columns 2 and 3 if column 1 is not zero, otherwise print the product of columns 4 and 3” From that, I thought I needed to write something like this: (C2!<1000)?C2*1.10:C2*1.50 Thinking that it provides the instruction to ascertain if C2 is under 1000, in which case multiply by 1.10, and otherwise multiply by 1.50. That doesn’t work in my report, returning a zero value all the way. Ideally, I’d prefer to create multiple rules in the expression, such as: If below 1000, add 10%. If above 1000 but below 2000 add 20%. If above 2000, but below 3000 add 30% and so on. Any ideas, please?