1. Attention: We have put together a thread with tips and a tutorial video to help with using the new software. Please take a moment to check out the thread here: Trapshooters.com Tutorial & Help Video.

OT: excel help

Discussion in 'Off Topic Threads' started by dblell, Jul 29, 2012.

Thread Status:
Not open for further replies.
  1. dblell

    dblell Member

    Joined:
    Jun 28, 2006
    Messages:
    44
    Location:
    Cincinnati, ohio
    working on a score sheet for shooting. the goal is to add 65% of the diff betwwen the actual score and 50 when the score is below 46. This part works when there is a score in the box, but returns a 33 when the box is blank/empty. the only way I have been able to stop this is to put a letter in the box. The formula then does not know what to do with the letter so nothing is returned.
    here is the formula

    =IF(F3>45,F3,(50-F3)*0.65+F3)

    where f3 is the box mentioned above.

    You can post on this thread or email
    Thanks in advance if you can help
    Lee
  2. pyrdek

    pyrdek Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,453
    Try this (f7 was used to so difference from your F3 formula

    =IF(F7<=0,"",IF(F7<=46,F7,(50-F7)*0.65)
  3. dblell

    dblell Member

    Joined:
    Jun 28, 2006
    Messages:
    44
    Location:
    Cincinnati, ohio
    pyrdek
    thanks for the help changed one thing and it worked just fine, but looks like 65% might be a little to much help. if you would like to see it work send me your email and I will send you the file.

    =IF(E3<=0,"",IF(E3>=46,E3,(50-E3)*0.65+E3))

    amazing the help you can get here
    Lee
  4. pyrdek

    pyrdek Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,453
    dbell,

    you have a PM waiting for you.
  5. dblell

    dblell Member

    Joined:
    Jun 28, 2006
    Messages:
    44
    Location:
    Cincinnati, ohio
    pyrdek

    responded to your pm with a PM
  6. cubancigar2000

    cubancigar2000 Active Member

    Joined:
    Jan 29, 1998
    Messages:
    10,416
    Location:
    Idaho
    The if formulas are pretty sensitive. Sometimes you just have to erase the form and start over and then they work
Thread Status:
Not open for further replies.