logical function

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 ""
 
B

Bob Phillips

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)
 
J

J.E. McGimpsey

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).
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top