Newbie needs help with formula

R

rochdalemark

Ok, I can do basic spread sheets in excel but anything trickier tha
percentages I get lost, so I'm looking for some help here.
The logic for the formula is as follows I need to use the figures i
cell1 to put a figure in cell2, if the amount in cell1 is below 60,00
then there is no change and the figure in cell2 will be as cell1, i
the figure in cell1 is between 60,000 and 90,000 then the figure i
cell2 needs to be cell1 plus 3%, if the figure in cell1 is above 90,00
then the figure in cell2 needs to be cell1 plus 5%.

I then need a cell3 which will give me the difference between cell
aand cell2 but thats the easy bit, I'll just subtract cell1 fro
cell2.

Any help would be greatly apreciated
 
P

pwdiaz

Okay, this formula should work for cell2:

=IF(A1>90000,(A1*1.05),IF(A1>60000,(A1*1.03),A1))

Pau
 
R

rochdalemark

Ok guys, thank you for that, I've got to take it a stage further now t
tidy it all up.

3 cells

cell1 adds up a set of figures and returns a total.

cell2 gives me 7% of cell1

cell3 if cell1 is less than 60,000 then cell3 will be same as cell
which is 7% of cell1, if cell1 is between 60,000 and 90,000 then cell
will be 10% of cell1, if cell1 is greater than 90,000 then cell3 wil
be 12% of cell1

thank you for any help in advanc
 
M

mangesh_yadav

cell1 is A1
cell2 is A2
cell3 is A3

enter the following formula in A3
=if(A1<60000,A2,if(A1>90000,1.12*A1,1.10*A1))



cell1 adds up a set of figures and returns a total.

cell2 gives me 7% of cell1

cell3 if cell1 is less than 60,000 then cell3 will be same as cell
which is 7% of cell1, if cell1 is between 60,000 and 90,000 then cell
will be 10% of cell1, if cell1 is greater than 90,000 then cell3 wil
be 12% of cell
 
R

rochdalemark

Theres something wrong with that formula, when I enter 60,000 into cell
the figure in cell 3 comes up with 66,000 which is cell1 + 10% and no
just the 10% because it's over 60,000, when I enter 90,000 I still ge
cell1 + 10%, I need to enter 90,000.01 to get the 12% and even then
get cell1 + 12& and not 12% of cell
 
R

rochdalemark

How about this

=IF(A1<60000,A2,IF(A1>89999.99,(A1)-(88%*A1),IF(A1<90000,(B30)-(90%*A1))))

It seams to work fine for all the values, less than 60,000, betwee
60,000 and 90,000, and above 90,000.

Please tell me if there is a flaw in this formula, as I say I'm ok a
the basics and thats it
 
Top