trying to return a blank cell if one of two conditions are met

[suicycoe]

Hello all and thank you for reading this.

I have a multi-sheet form. One sheet has the raw data and the other is putitng that data to a template format for a database import. Currently, I'm using =IFERROR(IF(raw!A2<1|""|raw!A2)|""), This works as intened, if there is a value in the A2 cell, then that value is printed to the template form. The database needs to see an empty cell if there is no data or it will import the formula to the database.

Setting up a new template has posed a problem. The data now includes cells with (blank) in them. The above formula will see that as a value >1 and print, "(blank)" to the template. I can't have this either. So, I 'm trying to create a formula that will look at a cell and if it is <1 or has the text (blank) to return a "" to the cell or if its >1 and not (blank) to print cells content.

My attempts at using "IF(or" and IF(and" have failed miserably any help would be greatly appreciated.

[6StringJazzer]

I'm using =IFERROR(IF(raw!A2<1|""|raw!A2)|""), This works as intened,

What exactly is intended? This syntax is not valid. Did you mean to use commas instead of vertical bars?

I think this matches your description:

Please Login or Register  to view this content.

[leelnich]

Perhaps this:
=IF(OR(raw!A2<1,raw!A2="(blank)"),"",raw!A2)

Apparently the data in A2 is supposed to be numeric. If so, is it a NUMBER, or TEXT of a number?
(Select A2, Click Clear..Clear Formats on the Home ribbon. Text will be left-justified. Numbers will be right-justified.)

If the values are actual numbers, this might be more robust:
=IF(and(ISNUMBER(raw!A2),raw!A2>=1),raw!A2,"")

[suicycoe]

@ 6stringjazzer

This does work as intended. This is pipe delimited instead of comma delimited. Works the same way, just use a different syntax. Some of my clients want reports in pipe delimited instead of comma. You make a change in the Region and Language setting to get this. https://www.howtogeek.com/howto/2145...ead-of-commas/.

When I plug in the above formula, I still getting the work (blank) to pass thru instead of being an empty cell.

[suicycoe]

@leelnich

This WORKED!!!

The first formula was the ticket. Worked great. Thank you !!!!

[6StringJazzer]

This does work as intended. This is pipe delimited instead of comma delimited. Works the same way, just use a different syntax. Some of my clients want reports in pipe delimited instead of comma. You make a change in the Region and Language setting to get this. https://www.howtogeek.com/howto/2145...ead-of-commas/.

I have never needed to do this and I am surprised to learn that the only way to change the comma to a pipe in a CSV file is to make a setting change in Windows. This is an unusual technique and it would help to mention this if you post a formula with nonstandard syntax.

When I plug in the above formula, I still getting the work (blank) to pass thru instead of being an empty cell.

Sorry, I thought you literally meant a blank cell, not the text string "(blank)"