Hi Ernest

You have 2 excellent solutions posted by Bob and JE.

I'm just curious to know why you are using 85.5 and 14.96 total 100.46 as
opposed to 85.11 and 14.89 total 100.00.

Regards

Roger Govier


Ernest Lai wrote:
Hi all,

I have a table of items with "value" "vat" and "total" Columns. I would
like to write a formulae to say

When value is less than 140.5 then change value to 85.5, vat to 14.96,
total to 100.46 Else no change.

so im guessings its something like:
X=1
If AX<140.5 then AX=85.5, BX=14.96, CX=100.46
Else AX=AX,BX=BX,CX=CX
Increment x

Or i could just copy and paste the If Then statment down all the columns and
forget the increment. Hopefully you will see what im trying to do.

Thanks in advance, any help is much appretiated as always.

Ernest Lai