+ Reply to Thread
Results 1 to 4 of 4

IF forumals, Autofill?

  1. #1
    Registered User
    Join Date
    10-12-2015
    Location
    Vidalia, Ga
    MS-Off Ver
    2010
    Posts
    9

    IF forumals, Autofill?

    I have some formatting I am trying to figure out.
    11 November 2015 Heater Receiving.xlsx

    Here is what I need:
    Column I to stay blank until column H is filled in, but when any value is entered into column H, I need column G- column H to fill into column I

    But I still need for the if functions (unless there is a better formula to input) for column K & L to stay working (currently K is True if column I & column F are ='s & Column L is true is Column H is 0)

    I am still learning formulas & such & this ability would make life so much easier!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: IF forumals, Autofill?

    in I2

    =IF(H2<>0,G2-H2,0)

    in J2

    =IF(I2<>0,I2-F2,0)

    in K2

    =IF(I2=F2,TRUE)

    in L2

    =IF(H2=0,TRUE)

  3. #3
    Registered User
    Join Date
    10-12-2015
    Location
    Vidalia, Ga
    MS-Off Ver
    2010
    Posts
    9

    Re: IF forumals, Autofill?

    This doesn't work for me. See it works assuming the H will not be =0. Column H can have any #, I only want it to subtract IF a # is entered into H. During the work time, H may not have a # entered (the current formula is =G1-H1 (at all times) which means column I always has a # in it, which throws our workers off, b/c there should show nothing received & it shows the correct qty received, even though nothing has been touched.

    For example:
    Column
    F G H I J
    Qty to Rec Release # to Start RL # Qty Finish # Received Difference
    100 120 120

    In this example we receive 100 peices, our Open PO is for 120 pc. As it stands, when they START receiving, column I (G1-H1)will show the full Qty in G b/c nothing is entered into H. However, nothing can be entered into H until they workers are DONE receiving. So I need for I to not apply the formula UNtil a number has been manually entered into Column H

    It should look like this while in progress
    Column
    F G H I J
    Qty to Rec Release # to Start RL # Qty Finish # Received Difference
    100 120

    & this when finished
    Column
    F G H I J
    Qty to Rec Release # to Start RL # Qty Finish # Received Difference
    100 120 20 100 0

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: IF forumals, Autofill?

    If H2=0, then I2=0 (or you could set I2 to blank) which is what you asked for! I2 is only calculated when h2 is NOT 0. same for J2.

    If you want cells to be blank, formulae need adjusting.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. case sensitive forumals
    By bjbboats in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-14-2015, 04:39 AM
  2. How to substitue variables in my function/forumals?
    By bankerguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2014, 06:33 PM
  3. How to substitue variables in my function/forumals?
    By bankerguy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2014, 06:32 PM
  4. How to substitue variables in my function/forumals?
    By bankerguy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2014, 06:23 PM
  5. Replies: 2
    Last Post: 06-05-2011, 09:46 PM
  6. Linking Forumals into One Cell
    By SportsScientist in forum Excel General
    Replies: 4
    Last Post: 06-18-2009, 11:45 AM
  7. Forumals Turning Off (ie., not working)?
    By Fattie in forum Excel General
    Replies: 1
    Last Post: 02-04-2007, 11:45 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1