checking a cell for blank or value

dharsana

Board Regular
Joined
Sep 7, 2002
Messages
58
hi,
I have a problem.I have a row which contains values and blanks.I want a formula which checks a particular cell and if that is blank , it checks another cell and if it is not blank then takes the value of that cell.What formula to use?.The cell may be a blank cell or cell may be having only formula without results(values).

Thanks in advance.

dharsana
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Are you looking for the first non-blank value in a row? If so, try...

=INDEX(Range,MATCH(TRUE,INDEX(Range<>"",0),0))

Hope this helps!
 
Upvote 0
hi,
sorry.I have not made myself clear ? The formula not checks the first blank cell.It checks a particular cell and if it is not blank, it takes that cell value.If that cell is blank then it should go to another cell and checks for value.If it contains a value it takes.


dharsana
 
Upvote 0
How do you determine which cell to check first? Is it the Nth cell in the range? Maybe some other way? Can you provide an example?
 
Upvote 0
Hi dharsana:

Domenic has already asked for some more information ... in the meantime, let us have a look at the following ...
Book1
ABCDEFGH
1particularCellanotherCellmyRow
2C5F5cells of interest
3#N/A66kresult
4
57d35k9
6
Sheet1


Is this what you are looking for?

Of course more questions still remain ... what happens if 'anotherCell' is also blank?
 
Upvote 0
hi,

I have a2 to p2 cells and I want a formula in p2 which should check m2,if it is not blank ,it should take m2 value,if m2 is blank then it should check k2 and if k2 is having value , it should take value of k2 and if k2 is blank it should value of e2.

Any formula for this?

dharsana
 
Upvote 0
Yeah see below since mine was incorrect. I had tested with zero instead of "" but thought there might be text, and didn't completely change formula as needed.
 
Upvote 0
Edit: Sorry ... Domenic has already got it!

babycody said:
Try this and let me know if this is what you want. =IF(M2>" ",M2,IF(K2>" ",K2,E2))
Hi babycody:

Do you mean ... =IF(M2<>"",M2,IF(K2<>"",K2,E2))
 
Upvote 0

Forum statistics

Threads
1,226,453
Messages
6,191,137
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top