formula

[OldManDtr]

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

 

[Aladin Akyurek]

On 2002-03-31 15:10, OldManDtr wrote:
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

In H11 enter:

=((LEFT((B11*D11)/1.75,2)+0)>=24)*((LEFT((B11*D11)/1.75,2)+0)<=33)*((B11*D11)/1.75)

Addendum: I used an inclusive between.

Aladin
This message was edited by Aladin Akyurek on 2002-03-31 15:23

 

[Duane]

I'm not sure if you want to compute if the value in B11 IS 24 or 33...the following formula will include 24 and 33...enter the following into h11

=IF(AND(B11>23.99,B11<33.1),(B11*D11)/1.75,0)