Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Formulas in One
Please help.
Want to create a formula that allows for: 1. if amount in cell next to it is less than an amount, to come up as one amount. 2. if amount in cell next to it is more than an amount, to come up as another amount, The difficult bit for myself... 3. if amount in cell next to it is more than another amount on top of that, to come up as another amount. If you can help, that would be fantastic. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Formulas in One
=IF(A1<10,1,IF(AND(A1=10, A1<20),2,IF(AND(A1=20, A1<30),3,4)))
"2604ashleigh" wrote: Please help. Want to create a formula that allows for: 1. if amount in cell next to it is less than an amount, to come up as one amount. 2. if amount in cell next to it is more than an amount, to come up as another amount, The difficult bit for myself... 3. if amount in cell next to it is more than another amount on top of that, to come up as another amount. If you can help, that would be fantastic. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Formulas in One
Thank you very much. One question, what does the '3' represent?
"Scott" wrote: =IF(A1<10,1,IF(AND(A1=10, A1<20),2,IF(AND(A1=20, A1<30),3,4))) "2604ashleigh" wrote: Please help. Want to create a formula that allows for: 1. if amount in cell next to it is less than an amount, to come up as one amount. 2. if amount in cell next to it is more than an amount, to come up as another amount, The difficult bit for myself... 3. if amount in cell next to it is more than another amount on top of that, to come up as another amount. If you can help, that would be fantastic. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Formulas in One
Ashleigh
Scot was simply using 1,2,3,4 as examples of answers when certain criteria were met Regards Michael M "2604ashleigh" wrote: Thank you very much. One question, what does the '3' represent? "Scott" wrote: =IF(A1<10,1,IF(AND(A1=10, A1<20),2,IF(AND(A1=20, A1<30),3,4))) "2604ashleigh" wrote: Please help. Want to create a formula that allows for: 1. if amount in cell next to it is less than an amount, to come up as one amount. 2. if amount in cell next to it is more than an amount, to come up as another amount, The difficult bit for myself... 3. if amount in cell next to it is more than another amount on top of that, to come up as another amount. If you can help, that would be fantastic. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Formulas in One
Michael,
I should have done a little more that just throw the formula out there because if you've never used an IF statement you're not likely to understand the parts of it. I'll be more careful next time. Thanks for stepping in. Scott "Michael M" wrote: Ashleigh Scot was simply using 1,2,3,4 as examples of answers when certain criteria were met Regards Michael M "2604ashleigh" wrote: Thank you very much. One question, what does the '3' represent? "Scott" wrote: =IF(A1<10,1,IF(AND(A1=10, A1<20),2,IF(AND(A1=20, A1<30),3,4))) "2604ashleigh" wrote: Please help. Want to create a formula that allows for: 1. if amount in cell next to it is less than an amount, to come up as one amount. 2. if amount in cell next to it is more than an amount, to come up as another amount, The difficult bit for myself... 3. if amount in cell next to it is more than another amount on top of that, to come up as another amount. If you can help, that would be fantastic. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Formulas in One
Hi,
Since then, another criteria has come along, and I'm not sure how to make it fit in. I also need 4. if amount in cell next to it, is certain text, how do I stop all these #value errors coming up? and allow for an amount to be entered in manually? Possible? Thanks "Scott" wrote: Michael, I should have done a little more that just throw the formula out there because if you've never used an IF statement you're not likely to understand the parts of it. I'll be more careful next time. Thanks for stepping in. Scott "Michael M" wrote: Ashleigh Scot was simply using 1,2,3,4 as examples of answers when certain criteria were met Regards Michael M "2604ashleigh" wrote: Thank you very much. One question, what does the '3' represent? "Scott" wrote: =IF(A1<10,1,IF(AND(A1=10, A1<20),2,IF(AND(A1=20, A1<30),3,4))) "2604ashleigh" wrote: Please help. Want to create a formula that allows for: 1. if amount in cell next to it is less than an amount, to come up as one amount. 2. if amount in cell next to it is more than an amount, to come up as another amount, The difficult bit for myself... 3. if amount in cell next to it is more than another amount on top of that, to come up as another amount. If you can help, that would be fantastic. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing multiple formulas at one time | Excel Worksheet Functions | |||
Multiple "if" formulas | New Users to Excel | |||
Formulas for Multiple sheets in a workbook | Excel Discussion (Misc queries) | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |