Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
crazy format/formula
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help with a formula PLEASE I am going crazy | Excel Discussion (Misc queries) | |||
HELP with crazy formula | Excel Worksheet Functions | |||
Formula driving me crazy | Excel Discussion (Misc queries) | |||
Formula is driving me crazy????? | Excel Worksheet Functions | |||
Help I am going crazy with this formula. | Excel Worksheet Functions |