Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Help Editing Formula

  1. #11
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,035
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-03-28 15:55, Charlie wrote:
    Yes the data is to appear in the Percentages column.
    Charlie
    And, in which cell is the first occurrence of January? Is "January" a true date or just entered as text?

    You said E3 has the % for January, and E4 % for February. Do you also have % for March etc in E5 etc.?

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The Months are entered as just text,they start in B8,and I only have 6% in E3 and 3% in E4, no other months are entered.

  3. #13
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Got it, relax, my fault.Dumb I know but I made a spelling error in February would you believe.Guess I have ben at it too long tonight and its a little late.
    sorry to be a pest.
    Thanks Charlie.

  4. #14
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,035
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-03-28 16:09, Charlie wrote:
    The Months are entered as just text,they start in B8,and I only have 6% in E3 and 3% in E4, no other months are entered.
    OK, Charlie.

    In E8 enter and copy down:

    =IF(OR(D8={"Paid in Full","Underpaid"}),0%,(B8="January")*$E$3+(B8="February")*$E$4)

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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