Return value of non-blank cell

  • Thread starter Thread starter Teri
  • Start date Start date
T

Teri

I have two columns, let's call them F and G. If a certain cell in column G
is blank, I need to return the value of column F. Any ideas? I have a
spreadsheet that is 13,000 rows. Thanks!
 
Where do you want 'to return the value of column F'?

Enter this in H2
=IF(G2="",F2,"What do you want to do if G2 is not blank?")

You can copy it down...
 
Hi,

You didn't tell us where you wanted to return the value to or what you
wanted to do if it is blank.

Standard way:

=IF(G1="",F1,"")

But if the entries in G1 are numbers or blank, no 0's or text then a short
formula would be:

=IF(G1,"",F1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Count from Blank & Non-Blank Cells 2
#VALUE 2
Count Number Of Times Values Appears Consecutively, Return Longest 5
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
Returning Value of Next Non-Blank Cell in Column 2
Only first of multiple If's returns results 4
Leave Blank If No Data 6

Back
Top