Finish Formula

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
 
A

A C

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
 
D

David McRitchie

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
--
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top