+ Reply to Thread
Results 1 to 4 of 4

need help in correcting the formula

  1. #1
    JE McGimpsey
    Guest

    Re: need help in correcting the formula

    If the cells will contain at least one user entry:

    =IF(COUNT(A2:B2)=2,"Error",SUM(C1,B2,-A2))

    If you want to generate the error message if neither A2 or B2 are filled
    in, or both are filled in:

    =IF(MOD(COUNT(A2:B2),2)=0,"Error",SUM(C1,B2,-A2))




    In article <97791E29-73B5-4EAF-BE7A-CF4FB2BCF902@microsoft.com>,
    "azmi" <azmi@discussions.microsoft.com> wrote:

    > C2=IF(A2=0,C1+B2,IF(B2=0,C1-A2,IF(A2&B2=,"0","ERROR")
    >
    > what im trying ti do is to make the formula to show an error message when
    > (A2 and B2) both cells have been entered with data at the same time. that is
    > to say i want the results to be generated from either A2 or B2, not both.
    > when both cells (A2 and B2) are entered with data it should show "ERROR".
    > this is the best way i could explain. please help.


  2. #2
    JE McGimpsey
    Guest

    Re: need help in correcting the formula

    If the cells will contain at least one user entry:

    =IF(COUNT(A2:B2)=2,"Error",SUM(C1,B2,-A2))

    If you want to generate the error message if neither A2 or B2 are filled
    in, or both are filled in:

    =IF(MOD(COUNT(A2:B2),2)=0,"Error",SUM(C1,B2,-A2))




    In article <97791E29-73B5-4EAF-BE7A-CF4FB2BCF902@microsoft.com>,
    "azmi" <azmi@discussions.microsoft.com> wrote:

    > C2=IF(A2=0,C1+B2,IF(B2=0,C1-A2,IF(A2&B2=,"0","ERROR")
    >
    > what im trying ti do is to make the formula to show an error message when
    > (A2 and B2) both cells have been entered with data at the same time. that is
    > to say i want the results to be generated from either A2 or B2, not both.
    > when both cells (A2 and B2) are entered with data it should show "ERROR".
    > this is the best way i could explain. please help.


  3. #3
    azmi
    Guest

    need help in correcting the formula


    C2=IF(A2=0,C1+B2,IF(B2=0,C1-A2,IF(A2&B2=,"0","ERROR")

    what im trying ti do is to make the formula to show an error message when
    (A2 and B2) both cells have been entered with data at the same time. that is
    to say i want the results to be generated from either A2 or B2, not both.
    when both cells (A2 and B2) are entered with data it should show "ERROR".
    this is the best way i could explain. please help.

  4. #4
    JE McGimpsey
    Guest

    Re: need help in correcting the formula

    If the cells will contain at least one user entry:

    =IF(COUNT(A2:B2)=2,"Error",SUM(C1,B2,-A2))

    If you want to generate the error message if neither A2 or B2 are filled
    in, or both are filled in:

    =IF(MOD(COUNT(A2:B2),2)=0,"Error",SUM(C1,B2,-A2))




    In article <97791E29-73B5-4EAF-BE7A-CF4FB2BCF902@microsoft.com>,
    "azmi" <azmi@discussions.microsoft.com> wrote:

    > C2=IF(A2=0,C1+B2,IF(B2=0,C1-A2,IF(A2&B2=,"0","ERROR")
    >
    > what im trying ti do is to make the formula to show an error message when
    > (A2 and B2) both cells have been entered with data at the same time. that is
    > to say i want the results to be generated from either A2 or B2, not both.
    > when both cells (A2 and B2) are entered with data it should show "ERROR".
    > this is the best way i could explain. please help.


+ 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