From: Dan on
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
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
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
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?