Finish Formula

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

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 said:
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
Click to expand...

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
 
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
--
 
You're welcome Bobby..........glad you got it working...........thanks for
reporting back.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top