checking a cell for blank or value

dharsana

Board Regular
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).

dharsana

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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!

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

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?

Hi dharsana:

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?

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

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.

Try...

=IF(M2<>"",M2,IF(K2<>"",K2,E2))

Hope this helps!

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

HI,

Thanks

dharsana

Replies
14
Views
2K
Replies
12
Views
338
Replies
1
Views
289
Replies
1
Views
222
Replies
23
Views
2K

1,203,356
Messages
6,054,927
Members
444,759
Latest member
TeckTeck

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.

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

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