need formula help
in [General]
|
From: tom on 5 Feb 2010 14:48 I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G39>30, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this?
From: Eduardo on 5 Feb 2010 14:54 Hi, =IF(AND(G39>0, G39<=7),3000,IF(AND(G39>7, G39<=14),5000,if(G39>14,7500))) "tom" wrote: > I'm trying to have a formula do 3 scenerios in one cell and have a partial > formula working: IF(AND(G39>30, G39<=7),3000) which equates to if cell G39 is > greater than 0 and less than or equal to 7 use 3000. I would like to > continue the formula that if G39 is greater than 7 and less than 14 use 5000 > and if G39 is greater than 14 use 7500. How can I do this?
From: Dan on 5 Feb 2010 15:00 =IF(AND(G39>30,G39<=7),3000,IF(AND(G39>7,G39<14),5000,IF(G39>14,7500,0) care to what is more important to you.. 1st items will cancel later items, even if they are also true. you can change the order in which they occur. "tom" wrote: > I'm trying to have a formula do 3 scenerios in one cell and have a partial > formula working: IF(AND(G39>30, G39<=7),3000) which equates to if cell G39 is > greater than 0 and less than or equal to 7 use 3000. I would like to > continue the formula that if G39 is greater than 7 and less than 14 use 5000 > and if G39 is greater than 14 use 7500. How can I do this?
From: tom on 5 Feb 2010 15:04 thank you! "Eduardo" wrote: > Hi, > > =IF(AND(G39>0, G39<=7),3000,IF(AND(G39>7, G39<=14),5000,if(G39>14,7500))) > > "tom" wrote: > > > I'm trying to have a formula do 3 scenerios in one cell and have a partial > > formula working: IF(AND(G39>30, G39<=7),3000) which equates to if cell G39 is > > greater than 0 and less than or equal to 7 use 3000. I would like to > > continue the formula that if G39 is greater than 7 and less than 14 use 5000 > > and if G39 is greater than 14 use 7500. How can I do this?
From: "David Biddulph" groups [at] on 5 Feb 2010 15:02
IF(G39<=0, "", IF(G39<=7,3000, IF(G39<14,5000, IF(G39>14,7500,"G39 is equal to 14")))) -- David Biddulph tom wrote: > I'm trying to have a formula do 3 scenerios in one cell and have a > partial formula working: IF(AND(G39>30, G39<=7),3000) which equates > to if cell G39 is greater than 0 and less than or equal to 7 use > 3000. I would like to continue the formula that if G39 is greater > than 7 and less than 14 use 5000 and if G39 is greater than 14 use > 7500. How can I do this? |