IF function which can find a blank cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
I have a spreadsheet like the following:

heading 1 heading 2 heading 3
213
212 24
213 7
214
215
216 12

What I need is a formula which can look into cell b2, and if it finds a
blank cell, return the value in cell A2, if it finds a value in cell B2 then
return that value.
How do I ask the if function to look for a blank cell?
Thanks for youe help.

Owl37
 
Try this in C2, and copy down as needed:

=A2*(B2="")+B2

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi all,
I have a spreadsheet like the following:

heading 1 heading 2 heading 3
213
212 24
213 7
214
215
216 12

What I need is a formula which can look into cell b2, and if it finds a
blank cell, return the value in cell A2, if it finds a value in cell B2 then
return that value.
How do I ask the if function to look for a blank cell?
Thanks for youe help.

Owl37
 
owl37 said:
Hi all,
I have a spreadsheet like the following:

heading 1 heading 2 heading 3
213
212 24
213 7
214
215
216 12

What I need is a formula which can look into cell b2, and if it finds a
blank cell, return the value in cell A2, if it finds a value in cell B2 then
return that value.
How do I ask the if function to look for a blank cell?
Thanks for youe help.

Owl37
Click to expand...

There are two different types of "blank" that you need to consider. Is
the cell truly blank (ie. nothing there) or is there a formula that
returns blank. If you want to consider the second case or both cases
you could say:

=IF(B2="",A2,B2)

If you are looking for cells that only consider the first case:

=IF(ISBLANK(B2),A2,B2)

Edward
 
Back
Top