logical function

  • Thread starter Thread starter debo
  • Start date Start date
D

debo

please what is the use of "" in a formula?

can you help breathis down for an hypothetical sheet

=IF(AND(I25<>"",I25<=$E$1),$L25*$H25/100,0)k

what i dont understand is the ""
 
Debo,

It is a way of testing for nothing in the cell. So
AND(I25<>"",I25<=$E$1)
is testing for the I25 to be not empty and less than or equal to the value
in E1,
If true, it returns the value of L25 multiplied by H25 divided by 100, else
it returns 0

The k at the end looks like a mistake

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
In a string comparison, a blank cell will be evaluated as a null
(zero-length) string, or "". Formulae can also return null strings.

So I25<>"" means that I25 is not blank (or contains a value other
than a null string).
 
Hi debo!

The "" is a blank cell or a cell containing a formula that resolves to
""

So with
=IF(AND(I25<>"",I25<=$E$1),$L25*$H25/100,0)

If I25 is an empty cell or contains a formula that resolves to ""
(e.g. =IF(A21=7,"",9) ) then the first part of the AND condition is
true.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top