You'll have to use some additional columns because otherwise you'll have a
circular reference.

Let's assume the following:

Column A ... Entered Value
Column B Entered VAT
Column C Entered Total
Column D Calculated Value
Column E Calculated VAT
Column F Calculated Total

A2=85.5
D2 =IF(A2<140.5,85.5,A2)
E2=IF(A2<140.5,14.96,B2)
F2=D2+E2 OR =IF(A2<140.5,85.5,C2)


"Ernest Lai" wrote in message
...
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