software

Hi

I,m trying to work this out ,the vat is currently set to work out the rate
in cell A1, I want to be able to make a formula where by if there is a value
in cell A2 then it no longer reads the cell A1 but reads the value in A2
instead.Thanks

A
1 fig1
2 fig2
3 VAT @ 17.5%
Ben try:

=IF(A2=quot;quot;,Your formula for VAT,A2)

--
HTH

Sandy
with @tiscali.co.ukquot;Benquot; gt; wrote in message
...
gt; Hi
gt;
gt; I,m trying to work this out ,the vat is currently set to work out the rate
gt; in cell A1, I want to be able to make a formula where by if there is a
gt; value
gt; in cell A2 then it no longer reads the cell A1 but reads the value in A2
gt; instead.Thanks
gt;
gt; A
gt; 1 fig1
gt; 2 fig2
gt; 3 VAT @ 17.5%
gt;
gt;
=IF(A2lt;gt;quot;quot;,A2,A1)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;Benquot; gt; wrote in message
...
gt; Hi
gt;
gt; I,m trying to work this out ,the vat is currently set to work out the rate
gt; in cell A1, I want to be able to make a formula where by if there is a
gt; value
gt; in cell A2 then it no longer reads the cell A1 but reads the value in A2
gt; instead.Thanks
gt;
gt; A
gt; 1 fig1
gt; 2 fig2
gt; 3 VAT @ 17.5%
gt;
gt;