Using OR Function With an ISBLANK Function

[Proj_Eng]

Hi Everyone,

I have what I hope will be a simple problem for the experts here to help me with. I'm using an ISBLANK Function in three separate cells on a sheet that references cells on another sheet named INPUT. If the referenced INPUT cell has no value I want the cell on the current sheet with the function to remain blank. As an example the function looks like the one below. It appears in cells K13, L12 and M14 on the sheet in question.

In a fourth cell on the current sheet (not INPUT) I have the following function:

When I hit enter I get a #VALUE error. Is there a work around for this? I also tried using an AND function in place of the OR function. Let me know if you need additional information to clarify my question. Any help would be appreciated. Thanks in advance.

Matt

[TMS]

The first one should probably be

Please Login or Register  to view this content.

[Proj_Eng]

Hi TMS,

I forgot to put the parenthesis around the cell. I have edited my post to correct it.

[Pete_UK]

You could shorten the first formula to this:

=INPUT!A1&""

if the cell contains text values (not numbers).

I'm not sure why you are testing the cells L12 and M14 for being empty in the second formula, when the rest of the formula doesn't use those cells. If you are getting a #VALUE error you are probably trying to perform arithmetic on a text value, so you will need to check out what those other cells actually contain. We can't tell, as you haven't attached a sample Excel workbook (see yellow banner at the top of the screen).

Hope this helps.

Pete

[Proj_Eng]

Hi Pete,

I have added a sample workbook to help see what I am talking about. Let me know if you have any questions.

[JeteMc]

Assuming the formula in question populates K19:K20 try pasting the following into cell K19 and then dragging the fill handle down:

Please Login or Register  to view this content.

Let us know if you have any questions.