Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie needs help with formula
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
help with formula - newbie | New Users to Excel | |||
newbie trouble with formula | New Users to Excel | |||
I'm a Newbie, Need Formula | Excel Discussion (Misc queries) | |||
need help with formula for a newbie excel guy | New Users to Excel |