Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
I am trying to construct a formula that will take colum "b2" and determine if
it is greater than $100,000; if the formula is, I need to take the amount that is greater than 100,000 and multiply it by .005, then add the 100,000 * ..00575. I have been away from Excel for a year, and I know that it can be done, but I'm too rusty and keep getting errors. Any suggestions would be appreciated. Thank you, Pam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
Try this, Pam:
=IF(B2100000,(B2-100000)*0.005+100000*0.00575,B2*0.00575) I have assumed that if B2 is less than or equal to 100,000 then you would want to multiply it by .00575. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
One way
=MAX(B2-100000,0)*0.005+MIN(100000,B2)*0.00575 to just get the values greater than 100000 use =MAX(B2-100000,0)*0.005 Regards, Peo Sjoblom "Pam" wrote: I am trying to construct a formula that will take colum "b2" and determine if it is greater than $100,000; if the formula is, I need to take the amount that is greater than 100,000 and multiply it by .005, then add the 100,000 * .00575. I have been away from Excel for a year, and I know that it can be done, but I'm too rusty and keep getting errors. Any suggestions would be appreciated. Thank you, Pam |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
If at all i understood right.....
=if(b2100000,((b2*.005)+(100000*.00575))) see if it works. GARY "Pam" wrote in message ... I am trying to construct a formula that will take colum "b2" and determine if it is greater than $100,000; if the formula is, I need to take the amount that is greater than 100,000 and multiply it by .005, then add the 100,000 * .00575. I have been away from Excel for a year, and I know that it can be done, but I'm too rusty and keep getting errors. Any suggestions would be appreciated. Thank you, Pam |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
I used this function, but thanks Pete, your's works too, and I haven't tried
the min max yet, but will. Thanks for all your help =IF(H8<=100000,SUM(H8*0.00575),SUM(H8-100000)*(0.005)+(575)) "Pam" wrote: I am trying to construct a formula that will take colum "b2" and determine if it is greater than $100,000; if the formula is, I need to take the amount that is greater than 100,000 and multiply it by .005, then add the 100,000 * .00575. I have been away from Excel for a year, and I know that it can be done, but I'm too rusty and keep getting errors. Any suggestions would be appreciated. Thank you, Pam |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
=if(b2100000,((b2*.005)+(100000*.00575)),"")
forgot to put the Value If False. now try. "Gary" wrote in message ... If at all i understood right..... =if(b2100000,((b2*.005)+(100000*.00575))) see if it works. GARY "Pam" wrote in message ... I am trying to construct a formula that will take colum "b2" and determine if it is greater than $100,000; if the formula is, I need to take the amount that is greater than 100,000 and multiply it by .005, then add the 100,000 * .00575. I have been away from Excel for a year, and I know that it can be done, but I'm too rusty and keep getting errors. Any suggestions would be appreciated. Thank you, Pam |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
Pam,
You do not need the SUM function he Wrong: =IF(H8<=100000,SUM(H8*0.00575),SUM(H8-100000)*(0.005)+(575)) Right: =IF(H8<=100000,(H8*0.00575),(H8-100000)*(0.005)+(575)) or even:=IF(H8<=100000,H8*0.00575,(H8-100000)*0.005+575) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then function
Thanks for feeding back, Pam.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |