1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

need help with excel

Discussion in 'Members' Lounge' started by pissedoffsol, Nov 6, 2003.

  1. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    54
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    so here i am, a certified computer nerd, and i can't figure this shit out.

    i need to calculate a cell for sales tax using the IF() function.

    =IF(State="CT",D12*0.06,0)

    where state = state defined cell
    d12 = subtotal
    .06 = ct state tax
    or, 0 if not ct.

    it comes up as #name in the field.... meaning a field is not recognized in the field.

    i tried using b5 instead of "state", and it gives the same error

    tried no quotes.... comes up always as false....
     
  2. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    54
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    nevermind. i figured it out myself :D

    i had a space in the "state field drop down, thus 'ct' != ' ct'
     
  3. Bob Vila

    Bob Vila ɐןıʌ qoq Admin VIP

    Messages:
    4,670
    Likes Received:
    57
    Joined:
    Jul 4, 2003
    Location:
    Bristol, Ct.
  4. CRX-YEM

    CRX-YEM Super Moderator Moderator VIP

    Messages:
    4,623
    Likes Received:
    54
    Joined:
    Sep 29, 2002
    Location:
    Wallingford, CT
    :D
    man I love excel formula's I wish I noticed this earlier

    look what I had to do yesterday to check some final test data of ours

    =IF(AND(AND(H3<=4.75,H3>=4.25),(AND(I3<=0.75,I3>=0.25))),"P","F")

    and on top of the formula is does conditional ormating, ie if the answer is P leave cell as is, if answer if F then turn cell Red.


    that's the cleaned up version.
    you should of seen the tring of nested If statements I was using.

    using excel functions are a bitch.
     
  5. Tonyd0821

    Tonyd0821 Banned

    Messages:
    5,088
    Likes Received:
    0
    Joined:
    Feb 26, 2003
  6. CRX_B16B

    CRX_B16B Senior Member

    Messages:
    386
    Likes Received:
    0
    Joined:
    Oct 7, 2003
  7. Bob Vila

    Bob Vila ɐןıʌ qoq Admin VIP

    Messages:
    4,670
    Likes Received:
    57
    Joined:
    Jul 4, 2003
    Location:
    Bristol, Ct.

    welcome to my world...
     
  8. Tonyd0821

    Tonyd0821 Banned

    Messages:
    5,088
    Likes Received:
    0
    Joined:
    Feb 26, 2003
  9. JDMilan

    JDMilan Senior Member

    Messages:
    6,730
    Likes Received:
    0
    Joined:
    May 11, 2003
    Location:
    Boca Raton, FL
    a decent reference source for excel formulas is that quick guide that college book stores usually sell, it only costs like 5 bucks and might be useful in the future for you B.
     
Verification:
Draft saved Draft deleted

Share This Page