+ Reply to Thread
Results 1 to 3 of 3

Please help, I'm stuck

  1. #1
    Ben
    Guest

    Please help, I'm stuck

    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%



  2. #2
    Ken Wright
    Guest

    Re: Please help, I'm stuck

    =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 :-)
    ------------------------------*------------------------------*----------------


    "Ben" <Ben@discussions.microsoft.com> wrote in message
    news:188C6B69-699C-4E15-9B35-51A50B8ED0D5@microsoft.com...
    > 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%
    >
    >




  3. #3
    Sandy Mann
    Guest

    Re: Please help, I'm stuck

    Ben try:

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

    --
    HTH

    Sandy
    sandymann2@mailinator.com
    Replace@mailinator.com with @tiscali.co.uk


    "Ben" <Ben@discussions.microsoft.com> wrote in message
    news:188C6B69-699C-4E15-9B35-51A50B8ED0D5@microsoft.com...
    > 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%
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1