Show blank cell when not Closed or Open

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

Guest

I have this formulas in column B: =IF(AH8>0,"Closed","Open")

When I copy this formula down column B into blank rows, Open appears in all
those cells below B8 of column B even though there is no data enter. I want
these cells to remain blank until data is entered to start the new row.
 
=IF(ISBLANK(A8),"",IF(A8>0,"Closed","Open"))
If you really mean AH8, then change above references from A8 to AH8.
 
Both responses worked.

Kleev said:
=IF(ISBLANK(A8),"",IF(A8>0,"Closed","Open"))
If you really mean AH8, then change above references from A8 to AH8.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Hide columns based on row values 2
sumif returns blank if all cells blank 7
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
Formula than understands midnight? 25
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Referenced cell change when row is blank 1

Back
Top