need formula help
in [General]
|
From: Dan on 5 Feb 2010 15:06 correction on formula, needs 2 more parenthesis =IF(AND(G39>30,G39<=7),3000,IF(AND(G39>7,G39<14),5000,IF(G39>14,7500,0))) "Dan" wrote: > =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: Mike H on 5 Feb 2010 15:07 Maybe a bit shorter =LOOKUP(G39,{0,8,15},{3000,5000,7500}) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "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: מיכאל (מיקי) אבידן on 6 Feb 2010 03:05 Does this segment make sense: AND(G39>30,G39<=7),... ? Micky "Dan" wrote: > correction on formula, needs 2 more parenthesis > =IF(AND(G39>30,G39<=7),3000,IF(AND(G39>7,G39<14),5000,IF(G39>14,7500,0))) > > "Dan" wrote: > > > =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: "David Biddulph" groups [at] on 6 Feb 2010 06:03
The 30 is a typo. If you look at the OP you'll see that it refers to zero. -- David Biddulph ????? (????) ????? wrote: > Does this segment make sense: AND(G39>30,G39<=7),... ? > Micky > > > "Dan" wrote: > >> correction on formula, needs 2 more parenthesis >> =IF(AND(G39>30,G39<=7),3000,IF(AND(G39>7,G39<14),5000,IF(G39>14,7500,0))) >> >> "Dan" wrote: >> >>> =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? |