On Tue, 5 Sep 2006, in microsoft.public.excel.charting,
Carlo said:
well, this is the formula which is in my "range"-cells:
=IF(OR(ROW()<MAX($H$5;$H$1);X7="");#N/A;100+(X7-INDIRECT("x" &
MAX($H$5;$H$1)))/INDIRECT("x" & MAX($H$5;$H$1))*100)

I need the #N/A, otherwise these points would show up on my Chart with zero!
If there would be another solution then the #N/A that would be great,

Ask on the Worksheet Functions forum (microsoft.public.excel.worksheet.
functions) about using array formulas to mimic a "MAXIF" type function.
This should let you keep using N/A in your column, but allow the MAX
function to ignore them.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.