+ Reply to Thread
Results 1 to 6 of 6

Need an IF formula that leaves the cell blank if equation is true

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    20

    Question Need an IF formula that leaves the cell blank if equation is true

    Hey Forum,

    I am trying to get this spread sheet to show blank in columns G, H, I, J when there is no data entered in column C. I can get it to show blank but that’s about it lol.
    This is the formula I came up with for G16. It accepts it and blanks out the box, but it stays blank once data is entered… don’t know what I am doing wrong, but the few things I tried caused a refusal of the formula. Once I have the frame work I can modify it for the other columns.

    =IF(AND(C16<>"",),D16+E16+F16, "")


    Thanks for your help!



    Sample for Forum.xlsx

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need an IF formula that leaves the cell blank if equation is true

    See the yellow cells in the attached file.

    You can use a simular formula for the other columns.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need an IF formula that leaves the cell blank if equation is true

    Thank you very much! I clearly over complicated it lol.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need an IF formula that leaves the cell blank if equation is true

    Thanks for the reply.

    Glad i could help.

    Will you mark the question solved, if it is solved.

    It you get other questions on this item, just ask or comment.

  5. #5
    Registered User
    Join Date
    03-21-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need an IF formula that leaves the cell blank if equation is true

    AIA Form.xlsx

    Okay got all the formulas entered and everything is working great. Thank you! I have one last section to tackle. I need an IF formula for Culumns D E and F, rows 29-38 on AIA 2!. The change order section. If the change order is a negitive number (a credit back to the customer) than I need that information to not only go to AIA 1! C17 but also AIA 1! C37 (if in row AIA 2! D) or AIA 1! C38 (if in row AIA 2! E:F). Any help on this would be great.

    Thanks,
    Alexander

  6. #6
    Registered User
    Join Date
    03-21-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need an IF formula that leaves the cell blank if equation is true

    Could I use DSUM Function? If yes how do I specify Negative amounts?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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