1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Formula help for Excel

Discussion in 'Other PC Software' started by RGettler, 2003/01/16.

Thread Status:
Not open for further replies.
  1. 2003/01/16
    RGettler

    RGettler Inactive Thread Starter

    Joined:
    2003/01/11
    Messages:
    5
    Likes Received:
    0
    In Excel, I want to write a formula that will force a value into an empty cell.

    Here's an example...

    =IF D14=4, then make K42=$3500, else 0.

    I need the cell to remain open, meaning not putting this formula in the K42 cell, so that under other conditions, a user can type any number they want into the cell as long as D14 does not equal 4. Is this possible?
     
    RGettler,
    #1
  2. 2003/01/17
    Daizy

    Daizy Inactive

    Joined:
    2002/02/19
    Messages:
    2,965
    Likes Received:
    0
    Hi Rgettler
    Perhaps some help here?? Please don't think for a moment that we're chasing you off. (We're most certainly not) Just trying to get you an answer quicker. :)

    Daizy
     
    Last edited: 2003/01/17
    Daizy,
    #2


  3. to hide this advert.

Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...