Jon Peltier Wrote:
-ABS(LOG(1-$A1)/LOG(1+$I$1))-
I'm confused by your apparent use of hyphen/minus sign for quotes. Do
you
mean this?
"ABS(LOG(1-$A1)/LOG(1+$I$1))"
Jon,
It's my turn to be confused
In my view of the forum message
the hyphens don't show up. I used (and hopefully this comes through
unscattered) either --LOG(1-$A$1)/LOG(1+$I$1)- or
-ABS(LOG(1-$A$1)/LOG(1+$I$1))-
Jon Peltier Wrote:
Since $A1 is always less than 1, 1-$A1 is always positive, but
log(1-$A1) is
either zero (if $A1 is 0) or negative (if $A10 and <0.999). If you're
plotting this function on a log scale, Excel will reject it. If you're
plotting ABS(this function) on the log scale, and there's an instance
where
$A1=0, then ABS(the function)=0 and Excel will again reject it.
You hit the nail on the head: I should start the $A range at a value
other than zero (e.g. 0.001) and then the message disappears. Excel,
after all, was right! Many Thanks
--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile:
http://www.excelforum.com/member.php...o&userid=15668
View this thread:
http://www.excelforum.com/showthread...hreadid=499144