have excel xp and some earlier versions as well. What I need to know is how to make a cell show a value of 0 given these conditions.in b11 I have entered a width and in d11 a height. I am going to mutilply b11*d11 then divide it by 1.75 and the answer is to go into h11 but only if it is within a certain range.
33*36/1.75=
I want it to place a value there but only if the begginning number(as in bll) is between 24 and 33 any lower would be 0 any higher would be 0 and its it is in the right range then it would equal the corret value instead of 0.
Have tried the IF function every way I can think of.
This message was edited by OldManDtr on 2002-03-31 15:13
33*36/1.75=
I want it to place a value there but only if the begginning number(as in bll) is between 24 and 33 any lower would be 0 any higher would be 0 and its it is in the right range then it would equal the corret value instead of 0.
Have tried the IF function every way I can think of.
This message was edited by OldManDtr on 2002-03-31 15:13