+ Reply to Thread
Results 1 to 5 of 5

IF function does not return blank in function cell

  1. #1
    Registered User
    Join Date
    08-26-2009
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    11

    IF function does not return blank in function cell

    I'm trying to get the 30000 figure in cell b39 to disappear so that the cell and all following cells in the b column are blank when there is no corresponding figure in column A . I have reproduced the functions that appear under colmn a and b. the column a formula works. HOever there is something wrong with the column be formula. it isn't stopping the 30000 figure from appearing. Is the problem using "" as the false reference in the IF function.

    A B
    36 2015 30000
    37 2016 30000
    38 2017 30000
    39 30000

    =IF(A32<$G$7, A32+1, "") =IF(A36>1,$G$10, "")
    =IF(A36<$G$7, A36+1,"") =IF(A37>1,$G$10, "")
    =IF(A37<$G$7, A37+1,"") =IF(A38>1,$G$10, "")
    =IF(A38<$G$7, A38+1,"") =IF(A39>1,$G$10, "")
    =IF(A39<$G$7, A39+1,"") =IF(A40>1,$G$10, "")
    =IF(A40<$G$7, A40+1,"") =IF(A41>1,$G$10, "")
    =IF(A41<$G$7, A41+1,"") =IF(A42>1,$G$10, "")



    sorry, but this isn't displaying correctly.
    Last edited by superdow; 09-02-2009 at 04:16 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: IF function does not return blank in function cell

    Hard to tell what you are doing.. post a sample workbook...
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: IF function does not return blank in function cell

    In A37:
    =IF(OR(A36=$G$7,A36=""),"",A36+1)

    In B37:
    =IF(A37="","",$G$10)
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  4. #4
    Registered User
    Join Date
    08-26-2009
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: IF function does not return blank in function cell

    Thanks! I didn't need to change the A column formula but your suggestion for the B column worked perfectly.

    Still I think my formula should have worked.

    A
    1 2009
    2 2010
    3 blank


    my cell b3
    =IF(A3>1,G10,"")


    Apparantly my formula only works if there is actually a number in A3.


    Your formula

    =IF(A3="","",G10)

    indeed works and returns a blank space in B3

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: IF function does not return blank in function cell

    If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


    (Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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