Finish Formula

1st thanks, don't know what I do with out your help.
Need help to finish this formula.

cell a1 I have $1500.00

cell c2 I have this formula that doesn't work but I think I'm on the
right track.
=IF(AND(a1>1212,a1<2683),(a1-601*0.25))+50

what I need to do is
1. check if cell a1 is between $1212.00 & $2683.00.
2. if it is I want to subtract $601.00 from cell a1 they * by 0.15
then add $50.00

Pretty simple think I have the 1st part of the formula right, and the
second part wrong.

Thanks for any and all help.
bobby

"Bobby" <[email protected]> wrote in message
news:[email protected]...
> 1st thanks, don't know what I do with out your help.
> Need help to finish this formula.
>
> cell a1 I have $1500.00
>
> cell c2 I have this formula that doesn't work but I think I'm on the
> right track.
> =IF(AND(a1>1212,a1<2683),(a1-601*0.25))+50
>
> what I need to do is
> 1. check if cell a1 is between $1212.00 & $2683.00.
> 2. if it is I want to subtract $601.00 from cell a1 they * by 0.15
> then add $50.00
>
> Pretty simple think I have the 1st part of the formula right, and the
> second part wrong.
>
> Thanks for any and all help.
> bobby

Did you mean *0.25 or *0.15??? Check you are using the right number...

The formula will be:
=IF(AND(a1>1212,a1<2683),(a1-601)*0.15+50,a1)

If it were me I would put the value 601 and 0.15 and 50 in their own cells
(eg E1 and F1 and G1 respectively) and that way you can change them and all
cells with the formula will pick up the change instantly. Eg something
like:

=IF(AND(a1>1212,a1<2683),(a1-$E$1)*$F$1+$G$1,a1)
This is only really applicable if you plan to use the formula in more than 1
cell, although it does make changing the values easier even if in only 1
cell.

Hope it helps
A

=IF(AND(A1>1212,A1<2683),((A1-601)*0.25)+50,"")

Vaya con Dios,
Chuck, CABGx3



"Bobby" <[email protected]> wrote in message
news:[email protected]...
> 1st thanks, don't know what I do with out your help.
> Need help to finish this formula.
>
> cell a1 I have $1500.00
>
> cell c2 I have this formula that doesn't work but I think I'm on the
> right track.
> =IF(AND(a1>1212,a1<2683),(a1-601*0.25))+50
>
> what I need to do is
> 1. check if cell a1 is between $1212.00 & $2683.00.
> 2. if it is I want to subtract $601.00 from cell a1 they * by 0.15
> then add $50.00
>
> Pretty simple think I have the 1st part of the formula right, and the
> second part wrong.
>
> Thanks for any and all help.
> bobby

Hi Bobby,

perhaps something like -- figure the upper limit is inclusive

=IF(AND(a1>1212,A1<=2683),(a1-601)*.15+50, A1)
or perhaps the last A1 is 0 or perhaps "" if you do not want a value for False
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bobby" <[email protected]> wrote in message news:[email protected]...
> 1st thanks, don't know what I do with out your help.
> Need help to finish this formula.
>
> cell a1 I have $1500.00
>
> cell c2 I have this formula that doesn't work but I think I'm on the
> right track.
> =IF(AND(a1>1212,a1<2683),(a1-601*0.25))+50
>
> what I need to do is
> 1. check if cell a1 is between $1212.00 & $2683.00.
> 2. if it is I want to subtract $601.00 from cell a1 they * by 0.15
> then add $50.00
>
> Pretty simple think I have the 1st part of the formula right, and the
> second part wrong.
>
> Thanks for any and all help.
> bobby

Thanks AC & CLR, been a big help.
Whit both of ya I got it to work.
Bobby

On Mon, 11 Jul 2005 21:39:21 -0400, "CLR" <[email protected]>
wrote:

>=IF(AND(A1>1212,A1<2683),((A1-601)*0.25)+50,"")
>
>Vaya con Dios,
>Chuck, CABGx3
>
>
>
>"Bobby" <[email protected]> wrote in message
>news:[email protected]...
>> 1st thanks, don't know what I do with out your help.
>> Need help to finish this formula.
>>
>> cell a1 I have $1500.00
>>
>> cell c2 I have this formula that doesn't work but I think I'm on the
>> right track.
>> =IF(AND(a1>1212,a1<2683),(a1-601*0.25))+50
>>
>> what I need to do is
>> 1. check if cell a1 is between $1212.00 & $2683.00.
>> 2. if it is I want to subtract $601.00 from cell a1 they * by 0.15
>> then add $50.00
>>
>> Pretty simple think I have the 1st part of the formula right, and the
>> second part wrong.
>>
>> Thanks for any and all help.
>> bobby
>

You're welcome Bobby..........glad you got it working...........thanks for
reporting back.

Vaya con Dios,
Chuck, CABGx3




"Bobby" <[email protected]> wrote in message
news:[email protected]...
> Thanks AC & CLR, been a big help.
> Whit both of ya I got it to work.
> Bobby
>
> On Mon, 11 Jul 2005 21:39:21 -0400, "CLR" <[email protected]>
> wrote:
>
> >=IF(AND(A1>1212,A1<2683),((A1-601)*0.25)+50,"")
> >
> >Vaya con Dios,
> >Chuck, CABGx3
> >
> >
> >
> >"Bobby" <[email protected]> wrote in message
> >news:[email protected]...
> >> 1st thanks, don't know what I do with out your help.
> >> Need help to finish this formula.
> >>
> >> cell a1 I have $1500.00
> >>
> >> cell c2 I have this formula that doesn't work but I think I'm on the
> >> right track.
> >> =IF(AND(a1>1212,a1<2683),(a1-601*0.25))+50
> >>
> >> what I need to do is
> >> 1. check if cell a1 is between $1212.00 & $2683.00.
> >> 2. if it is I want to subtract $601.00 from cell a1 they * by 0.15
> >> then add $50.00
> >>
> >> Pretty simple think I have the 1st part of the formula right, and the
> >> second part wrong.
> >>
> >> Thanks for any and all help.
> >> bobby
> >
>