I'm trying to get a formula to be between two numbers. Is my * my problem
I'm trying to get a formula to be between two numbers. Is my * my problem
"Mike" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to get a formula to be between two numbers. Is my * my problem
>=IF(D43>=45*D43<=87,"5.00","0.00")
Try this:
=AND(D43>=45,D43<=87)*5
Format as NUMBER 2 decimal places
Biff
Mike" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to get a formula to be between two numbers. Is my * my problem
Try
=if(and(D43>=45,D43<=87),"5.00","0.00")
is this what u need?
That work and i thought i could finsh the restbut can't could you look at
this please
=IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
"Biff" wrote:
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying to get a formula to be between two numbers. Is my * my problem
> >=IF(D43>=45*D43<=87,"5.00","0.00")
>
> Try this:
>
> =AND(D43>=45,D43<=87)*5
>
> Format as NUMBER 2 decimal places
>
> Biff
>
>
>
"Mike" wrote...
> That work and i thought i could finsh the restbut can't could you look at
> this please
>
> =IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
Try this:
=IF(AND(B44>14,B44<24,D44>44,D44<88,F44>999,F44<1276),75,IF(AND(B44>14,B44<24,D44>44,D44<88),37.5,0))
Biff
Gary,
this works but need to and two more cells and ranges to this formula could
this be done
"Gary" wrote:
> Mike" <[email protected]> wrote in message
> news:[email protected]...
>
> > I'm trying to get a formula to be between two numbers. Is my * my problem
>
>
> Try
>
> =if(and(D43>=45,D43<=87),"5.00","0.00")
>
> is this what u need?
>
>
>
Gary,
This works for but could i e-mail you my sheet and you may understand better
than i can explain it
"Biff" wrote:
> "Mike" wrote...
> > That work and i thought i could finsh the restbut can't could you look at
> > this please
> >
> > =IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
>
> Try this:
>
> =IF(AND(B44>14,B44<24,D44>44,D44<88,F44>999,F44<1276),75,IF(AND(B44>14,B44<24,D44>44,D44<88),37.5,0))
>
> Biff
>
>
>
>
>
sure..send it to [email protected]
"Mike" <[email protected]> wrote in message
news:[email protected]...
> Gary,
> This works for but could i e-mail you my sheet and you may understand
> better
> than i can explain it
>
> "Biff" wrote:
>
>> "Mike" wrote...
>> > That work and i thought i could finsh the restbut can't could you look
>> > at
>> > this please
>> >
>> > =IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
>>
>> Try this:
>>
>> =IF(AND(B44>14,B44<24,D44>44,D44<88,F44>999,F44<1276),75,IF(AND(B44>14,B44<24,D44>44,D44<88),37.5,0))
>>
>> Biff
>>
>>
>>
>>
>>
I sent if you have any ? you can e-mail me
"Gary" wrote:
> sure..send it to [email protected]
>
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> > Gary,
> > This works for but could i e-mail you my sheet and you may understand
> > better
> > than i can explain it
> >
> > "Biff" wrote:
> >
> >> "Mike" wrote...
> >> > That work and i thought i could finsh the restbut can't could you look
> >> > at
> >> > this please
> >> >
> >> > =IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
> >>
> >> Try this:
> >>
> >> =IF(AND(B44>14,B44<24,D44>44,D44<88,F44>999,F44<1276),75,IF(AND(B44>14,B44<24,D44>44,D44<88),37.5,0))
> >>
> >> Biff
> >>
> >>
> >>
> >>
> >>
>
>
>
I got the file but can u just write in words what u need.
"Mike" <[email protected]> wrote in message
news:[email protected]...
>I sent if you have any ? you can e-mail me
>
>
>
> "Gary" wrote:
>
>> sure..send it to [email protected]
>>
>> "Mike" <[email protected]> wrote in message
>> news:[email protected]...
>> > Gary,
>> > This works for but could i e-mail you my sheet and you may understand
>> > better
>> > than i can explain it
>> >
>> > "Biff" wrote:
>> >
>> >> "Mike" wrote...
>> >> > That work and i thought i could finsh the restbut can't could you
>> >> > look
>> >> > at
>> >> > this please
>> >> >
>> >> > =IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))
>> >>
>> >> Try this:
>> >>
>> >> =IF(AND(B44>14,B44<24,D44>44,D44<88,F44>999,F44<1276),75,IF(AND(B44>14,B44<24,D44>44,D44<88),37.5,0))
>> >>
>> >> Biff
>> >>
>> >>
>> >>
>> >>
>> >>
>>
>>
>>
Try this. Enter as an array formula
Please Login or Register to view this content.
Hi MIke, this is what i think u need and hope this would do what u r looking
for.
=IF(AND(B43>=14.1,B43<=23,D43>=45,D43<=87,E43>=1000,E43<=1275),"$75.00",IF(OR(AND(D43>=45,D43<=87,E43>=1000,E43<=1275),AND(B43>=14.1,B43<=23,D43>=45,D43<=87)),"$37.5","0.00"))
"edwardpestian" <[email protected]>
wrote in message
news:[email protected]...
>
> Try this. Enter as an array formula
>
>
> Code:
> --------------------
>
>
> =IF((B44>14)*(B44<24)*(D44>44)*(D44<88)*(F44>999)*(F44<1276),"
> $75.00",IF((B44>14)*(B44<24)*(D44>44)*(D44<88),"$37.50","$0.00"))
>
>
> --------------------
>
>
> --
> edwardpestian
> ------------------------------------------------------------------------
> edwardpestian's Profile:
> http://www.excelforum.com/member.php...o&userid=33809
> View this thread: http://www.excelforum.com/showthread...hreadid=562311
>
Sorry, I entered E instead of F
this is working fine now.
=IF(AND(B43>=14.1,B43<=23,D43>=45,D43<=87,F43>=1000,F43<=1275),"$75.00",IF(OR(AND(D43>=45,D43<=87,F43>=1000,F43<=1275),AND(B43>=14.1,B43<=23,D43>=45,D43<=87)),"$37.5","0.00"))
"Gary" <[email protected]> wrote in message
news:%[email protected]...
> Hi MIke, this is what i think u need and hope this would do what u r
> looking for.
>
> =IF(AND(B43>=14.1,B43<=23,D43>=45,D43<=87,E43>=1000,E43<=1275),"$75.00",IF(OR(AND(D43>=45,D43<=87,E43>=1000,E43<=1275),AND(B43>=14.1,B43<=23,D43>=45,D43<=87)),"$37.5","0.00"))
> "edwardpestian"
> <[email protected]> wrote in
> message news:[email protected]...
>>
>> Try this. Enter as an array formula
>>
>>
>> Code:
>> --------------------
>>
>>
>> =IF((B44>14)*(B44<24)*(D44>44)*(D44<88)*(F44>999)*(F44<1276),"
>> $75.00",IF((B44>14)*(B44<24)*(D44>44)*(D44<88),"$37.50","$0.00"))
>>
>>
>> --------------------
>>
>>
>> --
>> edwardpestian
>> ------------------------------------------------------------------------
>> edwardpestian's Profile:
>> http://www.excelforum.com/member.php...o&userid=33809
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=562311
>>
>
>
"edwardpestian" wrote...
> Try this. Enter as an array formula
> Code:
> =IF((B44>14)*(B44<24)*(D44>44)*(D44<88)*(F44>999)*(F44<1276),"
> $75.00",IF((B44>14)*(B44<24)*(D44>44)*(D44<88),"$37.50","$0.00"))
No need to array enter, just enter normally.
I'd be willing to bet a huge amount of money that the OP intends the result
to be NUMERIC, so:
=IF((B44>14)*(B44<24)*(D44>44)*(D44<88)*(F44>999)*(F44<1276),75,IF((B44>14)*(B44<24)*(D44>44)*(D44<88),37.5,0))
Then just format as CURRENCY 2 decimal places.
Biff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks