Don't test for blanks using ISBLANK()

=IF(ISBLANK(A1),.95*Z100,A1)

instead use:

=IF(A1="",.95*Z100,A1)

The ISBLANK() function is misnamed. It should have been called ISEMPTY()


For example, if you enter:
="" in A1
ISBLANK(A1) will report FALSE!!
--
Gary''s Student - gsnu200856


"Zeke" wrote:

I have a spreadsheet that shows either a price or a discount (never has both)
based on given quantities. I have a formula that goes and looks at each cell
to determine which to use. I am using the IFBLANK function. If the price
cell is blank, it applies a discount to another number in the sheet. If the
price cell is not blank, it uses that price. The problem I have is that some
cells it considers to not be blank are blank. I can copy and paste a "blank"
cell to another cell and there is nothing in there. If I click a random cell
and type ="blank cell #", it is blank. Now, if I double click that cell and
hit enter (without entering anything), it then treats the cell as blank. I
have over 14,000 lines and about 8 rows of this data that I would like to
avoid having to double click each blank row to get this to work. Any
suggestions?