Okay all the big brains, I have what is probably a simple formula that has been stumping me for two days now. I did not find a specifically related thread so I'm adding this one.
Problem:
I want a cell to give a value based on two separate cells.
The first is a standard number cell.
The second is a standard number cell.
The problem. The First cell (C6) is a number between 1 and say 50 that the user fills in.
The number in this cell dictates what percentage the second cell (C13) is multiplied by to give the desired amount.
The end goal is to have my desired cell decide which number range is in (C6) X,Y,Z and then take (C13) multiplied by a percentage that is decided based on the value in (C6)
So Ill list the names of the cells as follows:
(C6) is a whole number greater than zero and less than 50 - input by user
-If the value in C6 is less than 4 then C13 should be multiplied by 50% so that the result shows 50% of C13 in my designated cell.
-If the value in C6 is greater than or equal to 4 but less than 10 then C13 should be multiplied by 75% so that the result shows 75% of C13 in my designated cell.
-If the value in C6 is greater than or equal to 10 my designated cell should show 100% of C13's in my designated cell.
This is one of the formulas I came up with but it not working.
=IF((AND(C6<4,C6>=0)),C13*.5)IF(AND(C6>=4,C6<10),C13*.75)IF(C6>=10,C13*1)
------If i take the above formula and put it in one if statement at a time as just if statements, or IF(OR they work, but all three in one line doesn't. I'm lost.
This provides an error message and Excel tries to correct it this way: (adding multiplication between statements)
=IF((AND(C6<4,C6>=0)),C13*.5)*IF(AND(C6>=4,C6<10),C13*.75)*IF(C6>=10,C13*1)
What this formula is trying to do:
I want to show that based on years of service with a company X% of benefits are paid for by the company.
<4 years of service -- years 50% paid for
>=4 years but <10 years -- 75% paid for
>=10 years -- 100% paid for
Taking cost multiplied by % received based on ranges = desired $paid for
Any assistance with this is greatly appreciated.
Thanks in advance,
T-Wisely
Problem:
I want a cell to give a value based on two separate cells.
The first is a standard number cell.
The second is a standard number cell.
The problem. The First cell (C6) is a number between 1 and say 50 that the user fills in.
The number in this cell dictates what percentage the second cell (C13) is multiplied by to give the desired amount.
The end goal is to have my desired cell decide which number range is in (C6) X,Y,Z and then take (C13) multiplied by a percentage that is decided based on the value in (C6)
So Ill list the names of the cells as follows:
(C6) is a whole number greater than zero and less than 50 - input by user
-If the value in C6 is less than 4 then C13 should be multiplied by 50% so that the result shows 50% of C13 in my designated cell.
-If the value in C6 is greater than or equal to 4 but less than 10 then C13 should be multiplied by 75% so that the result shows 75% of C13 in my designated cell.
-If the value in C6 is greater than or equal to 10 my designated cell should show 100% of C13's in my designated cell.
This is one of the formulas I came up with but it not working.
=IF((AND(C6<4,C6>=0)),C13*.5)IF(AND(C6>=4,C6<10),C13*.75)IF(C6>=10,C13*1)
------If i take the above formula and put it in one if statement at a time as just if statements, or IF(OR they work, but all three in one line doesn't. I'm lost.
This provides an error message and Excel tries to correct it this way: (adding multiplication between statements)
=IF((AND(C6<4,C6>=0)),C13*.5)*IF(AND(C6>=4,C6<10),C13*.75)*IF(C6>=10,C13*1)
What this formula is trying to do:
I want to show that based on years of service with a company X% of benefits are paid for by the company.
<4 years of service -- years 50% paid for
>=4 years but <10 years -- 75% paid for
>=10 years -- 100% paid for
Taking cost multiplied by % received based on ranges = desired $paid for
Any assistance with this is greatly appreciated.
Thanks in advance,
T-Wisely
