You should be using plain text in these forums, if you're not already. The
two bits you included in your first para we

--LOG(1-$A$1)/LOG(1+$I$1)- [two leading hyphens and one trailing]
-ABS(LOG(1-$A$1)/LOG(1+$I$1))- [single leading and trailing hyphens]

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"rvExcelNewTip"
wrote in message
news:rvExcelNewTip.21ik9a_1137055801.4814@excelfor um-nospam.com...

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