return a value based on several conditions...

firebirdone · May 2nd, 2002, 03:34 PM

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 · May 2nd, 2002, 03:40 PM

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 · May 2nd, 2002, 03:44 PM

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

firebirdone · May 2nd, 2002, 03:55 PM

Thank you Asala42. It worked.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 03:34 PM	#1
firebirdone New Member Join Date: May 2002 Posts: 3	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 ]

May 2nd, 2002, 03:40 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	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

May 2nd, 2002, 03:44 PM	#3
firebirdone New Member Join Date: May 2002 Posts: 3	Let me try and I'll let you know. Thank you.

May 2nd, 2002, 03:55 PM	#4
firebirdone New Member Join Date: May 2002 Posts: 3	Thank you Asala42. It worked.