Its just a Boolean factor. if K108 is blank, then the factor is zero and so
is the final result.
--
Gary's Student
gsnu200702


"Ardy" wrote:

Thnaks Both Method Works OK,
I used =((100-(K108*0.45))/100)*(K108<""), Could you explain
(K108<"") is this another way of saying IF null

Ardy
JE McGimpsey wrote:
One way:

=IF(A1="",0,1-D188*0.0045)

In article . com,
"Ardy" wrote:

Hello All:
I have two cells A1 and A2 . Am calculating Percentile in cell A2.
The input is Cell A1. Please don't get hung-up on the formula in
Cell A2. it works for what I am trying to do the problem is that 0 is
also calculated as %100 which is correct( we are capturing the number
of errors - so 0 error is %100 which is no error).

The Problem is that if cell A1 is null this also reads as %100 in A2,
which creates a problem. Is there any way to have the formula read
null as null, so the percentile reflect %0.

A1 = User input
A2 =(100-(D188*0.45))/100

Ardy