| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
math question Excel 2000
I have a situation where a simple true false situation does not apply. How
do you create a formula for several IF situations in a single cell. I need to automate an entry so the person does not have to make a decision about how to calculate a value TIA Steve L. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
math question Excel 2000
Steve, more info might help, but here is and example of a nested if
= IF($L$1J9,K9-$L$1,IF($L$1I9,J9-$L$1,IF($L$1H9,I9-$L$1,H9-$L$1))) "Steve Lenaghan" wrote in message ... I have a situation where a simple true false situation does not apply. How do you create a formula for several IF situations in a single cell. I need to automate an entry so the person does not have to make a decision about how to calculate a value TIA Steve L. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 and date math | Excel Discussion (Misc queries) | |||
| Math Question | Excel Worksheet Functions | |||
| How do I ? math/excel question | Excel Discussion (Misc queries) | |||
| Math Question | New Users to Excel | |||
| Excel 2000 math question, repost | Excel Programming | |||
Linear Mode
