# IF function does not return blank in function cell

1. ## 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.

2. ## Re: IF function does not return blank in function cell

Hard to tell what you are doing.. post a sample workbook...

3. ## 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)

4. ## 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.

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

indeed works and returns a blank space in B3

5. ## 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)

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

#### 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