Please help, I'm stuck

B

Ben

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%
 
S

Sandy Mann

Ben try:

=IF(A2="",Your formula for VAT,A2)

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
K

Ken Wright

=IF(A2<>"",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 :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Excel - Wich Function should I use? 1
Formula fill series? 1
=if using cells with % or text 2
is there a formula for working out vat without repeating *17.5% 4
calculating a sum that contains a 0 or no data 7
Search cell value in same column 3
circular error problem for vat calc 9

Top