Newbie needs help with formula
 

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

--
Message posted from http://www.ExcelForum.com

Newbie needs help with formula
 

This should do it:

=IF(A3<60000,A3,IF(A3<=90000,A3*1.03,A3*1.05)

--
Message posted from http://www.ExcelForum.com

Newbie needs help with formula
 

Okay, this formula should work for cell2:

=IF(A190000,(A1*1.05),IF(A160000,(A1*1.03),A1))

Pau

--
Message posted from http://www.ExcelForum.com

Newbie needs help with formula
 

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

--
Message posted from http://www.ExcelForum.com

Newbie needs help with formula
 

BUMP :) Anyone help with this?


---
Message posted from http://www.ExcelForum.com/

Newbie needs help with formula
 

cell1 is A1
cell2 is A2
cell3 is A3

enter the following formula in A3
=if(A1<60000,A2,if(A190000,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

--
Message posted from http://www.ExcelForum.com

Newbie needs help with formula
 

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

--
Message posted from http://www.ExcelForum.com

Newbie needs help with formula
 

How about this

=IF(A1<60000,A2,IF(A189999.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

--
Message posted from http://www.ExcelForum.com