| 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? |
| 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 | |||
Threaded Mode
