i have a series of columns.
a b c d
e
1 Material, allowable max, actual max, needed value, add. material
2 16-003 0.42
3 16-004 0.45 0.51 'x'
4 16-004 0.45 0.40 0 16-001
where the 'needed value' will give me a value of 'x' which will be a
property of another material, which will reduce the actual max to the
allowable max if the additional material used has that particular value.(see
row 4)
dont worry about those formulas.

i would like to know if its possible to hide the '0.45' in the allowable max
column if no additional material is needed. (see row 2)
my problem lies he
if( the min value needed0, then show the max allowable, otherwise hide it)
if material is added, the required max is hidden, and the max allowable
can't see it, so it's no longer less than the required max.... so i need
extra material... and it keeps going and going

any thoughts on how to keep the values, but not show them?
thanks,