Excel help.

Discussion in 'Windows - Software discussion' started by i_am_alex, Apr 6, 2008.

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

    i_am_alex Regular member

    Joined:
    Sep 2, 2007
    Messages:
    381
    Likes Received:
    0
    Trophy Points:
    26
    Alright, I got basic knledge in Excel, I'm no master though. I need someone to help me make a formula, so my sheet will do the following:

    When I insert the word "Yes" into H15, it will subtract 5% in J15.

    If this was typed in J15: =G15*A15
    I would want it to change to =G15*A15/100*95 once I type Yes into H15.

    I also want the formula to stay the same if I type "No".

    I tried using the IF function, but it doesn't make much sense to me.

    Thanks in advance.
     
    i_am_alex, Apr 6, 2008
    #1
Thread Status:
Not open for further replies.

Share This Page