not sure how "18" crept in

=IF(Xinput= 8,Xinput-(1e-12),Xinput)

ie ensure the input is a tad less than 8 or less than the maximum xValue

Peter T

"Peter T" <peter_t@discussions wrote in message
...

i mean i would not
want to change the values from 8 to 8.00000001 in the example.


If you really don't want to change the 8, include an additional step for
your inputs (following in named cell xi or H1 in the previous example).

=IF(Xinput= 8,Xinput-18e-12,Xinput)
or
=IF(Xinput= MAX(xx),Xinput-0.000000000018,Xinput)

similar for the Yinput

Regards,
Peter T