A
alldreams
could you suggest alternative ways to state this formula?
R
RagDyeR
Sure - try this
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
could you suggest alternative ways to state this formula?
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
could you suggest alternative ways to state this formula?
K
Ken Wright
At a rough guess 
, perhaps you can take out chunks of it and define it as a
named formula, eg:-
Insert / Name / Define
In the box at the bottom put say
=(MAXA(B12:U12)-U14)/(MAXA(B12:U12)-MINA(B13:U13))
and call it perhaps COND1
You can then replace all instances in your formula of
=(MAXA(B12:U12)-U14)/(MAXA(B12:U12)-MINA(B13:U13))
with COND1 and so on.
VLOOKUP tables are often another way to go, or build bits of the formula into
other cells and then reference the result of those cells.
, perhaps you can take out chunks of it and define it as anamed formula, eg:-
Insert / Name / Define
In the box at the bottom put say
=(MAXA(B12:U12)-U14)/(MAXA(B12:U12)-MINA(B13:U13))
and call it perhaps COND1
You can then replace all instances in your formula of
=(MAXA(B12:U12)-U14)/(MAXA(B12:U12)-MINA(B13:U13))
with COND1 and so on.
VLOOKUP tables are often another way to go, or build bits of the formula into
other cells and then reference the result of those cells.