| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I do several formulas in one cell?
I am in the process of trying to get this formula to work.
=IF(C80,200,0)*OR(C8<3,200,0)*OR(C8=3,350)*AND(C8 3,350)*OR(C8<5,350)*OR(C85,500)*OR(C8=5,500) For example I am trying to figure times. So greater than 0 and less than 3 = 200 plus equal to 3, greater than 3 and less than 5 = 350, great than 5 = 500. For some reason it's just calculating the first formula for 200. Can anyone please help with this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do several formulas in one cell?
See if this does what you're looking for:
=IF(C8=5,500,IF(C8=3,350,IF(C8=0,200,0))) HTH, Elkar "imktew" wrote: I am in the process of trying to get this formula to work. =IF(C80,200,0)*OR(C8<3,200,0)*OR(C8=3,350)*AND(C8 3,350)*OR(C8<5,350)*OR(C85,500)*OR(C8=5,500) For example I am trying to figure times. So greater than 0 and less than 3 = 200 plus equal to 3, greater than 3 and less than 5 = 350, great than 5 = 500. For some reason it's just calculating the first formula for 200. Can anyone please help with this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do several formulas in one cell?
In this case you can use the following formula
=200*(C80)+150*(C83)+150*(C85) On a side note, you are using AND and OR incorrectly. The following formula will also do what you describe. =IF(C8<=0,0,IF(AND(C80,C8<=3),200,IF(AND(C83,C8< =5),350,IF(C85,500)))) of course it can be simplified to what has already been offered (with a slight modification) to this =IF(C85,500,IF(C83,350,IF(C80,200,0))) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do several formulas in one cell?
It all worked except for the=0,200 - It put in 200 and it should have been 0.
THANKS! "Elkar" wrote: See if this does what you're looking for: =IF(C8=5,500,IF(C8=3,350,IF(C8=0,200,0))) HTH, Elkar "imktew" wrote: I am in the process of trying to get this formula to work. =IF(C80,200,0)*OR(C8<3,200,0)*OR(C8=3,350)*AND(C8 3,350)*OR(C8<5,350)*OR(C85,500)*OR(C8=5,500) For example I am trying to figure times. So greater than 0 and less than 3 = 200 plus equal to 3, greater than 3 and less than 5 = 350, great than 5 = 500. For some reason it's just calculating the first formula for 200. Can anyone please help with this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do several formulas in one cell?
OH, THIS IS GREAT! It WORKED! THANK U, THANK U, THANK U Very Much!
"Sloth" wrote: In this case you can use the following formula =200*(C80)+150*(C83)+150*(C85) On a side note, you are using AND and OR incorrectly. The following formula will also do what you describe. =IF(C8<=0,0,IF(AND(C80,C8<=3),200,IF(AND(C83,C8< =5),350,IF(C85,500)))) of course it can be simplified to what has already been offered (with a slight modification) to this =IF(C85,500,IF(C83,350,IF(C80,200,0))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
| How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
| Cell Formulas | Excel Discussion (Misc queries) | |||
| Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
| change cell value greater than another cell value using formulas | Excel Worksheet Functions | |||
Linear Mode
