return a value based on several conditions...

[firebirdone]

What I want is a value return if several conditions are met. If x< .25 then return 0. If x is between .299 and .399 then return .25...and so on. Is this possible?
This message was edited by firebirdone on 2002-05-02 14:36
This message was edited by firebirdone on 2002-05-02 14:39

 

[Asala42]

Hey,

Sure thing. You can either use a nested if statement (up to 7 in one formula) or a vlookup.

In your example:

=IF(A2<0.25,0,IF(AND(A2>0.3,A2<0.4),0.25,IF(next criteria and so on ))

I'd give you a better formula if I knew all your conditions.

Hope that helps,
Adam

 

[firebirdone]

Let me try and I'll let you know. Thank you.

 

[firebirdone]

Thank you Asala42. It worked.