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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
crazy format/formula
It is not clear how the 'min value' is computed
An IF statement on the lines of =IF(min_value0, min_value, "") should do what you want --- that is a pair of double-quotes with nothing between them If I have misread the Q, then maybe you should look in conditional formatting. It is possible to hide say B2 based on the value of say D2 by making B2's font the same colour as the cell's background best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Derrick" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
crazy format/formula
Use conditional formating with font color = background color.
HTH Daniel 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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
crazy format/formula
lol the min value is a complicated formula...
=IF(OR(AE7=AD7,AG7=AF7,AI7=AH7),MAX(IF(AND(AE7 =AD7,AD7*AE7<0),((5*AB7*U7^4/(384*10000000*AD7))-(G7+M7))/2.9,0),IF(AND(AG7=AF7,AG7*AF7<0),((AG7*G7/AF7)+G7)/2.9,0),IF(AND(AI7=AH7,AH7*AI7<0),((AI7*M7/AH7)+M7)/2.9,0)),0) if u wanna know hahah also, the cell contents i want to hide are the max allowable - which are related to everything else. but i think i can go with the conditional formats.. and the same background.. that probably will work.. except for if i want to do the 'every other row is light green so i can see where im looking' thing thanks for helpin "Bernard Liengme" wrote: It is not clear how the 'min value' is computed An IF statement on the lines of =IF(min_value0, min_value, "") should do what you want --- that is a pair of double-quotes with nothing between them If I have misread the Q, then maybe you should look in conditional formatting. It is possible to hide say B2 based on the value of say D2 by making B2's font the same colour as the cell's background best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Derrick" wrote in message ... 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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
crazy format/formula
im afraid its a bit too complicated for that.
so cell Max_Allowable must be 'hidden' when Min_Needed = 0, Visible when Min_Needed < 0 the problem now is that if i want to conditionally format the Max_Allowable column, o can only compare values with "Max_Allowable", not the "Min_needed" i'd like to compare it with otherwise, ur background colour is what i need thanks, "Daniel.C" wrote: Use conditional formating with font color = background color. HTH Daniel 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, |
Reply |
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 |