math question Excel 2000

  • Thread starter Thread starter Steve Lenaghan
  • Start date Start date
S

Steve Lenaghan

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.
 
Steve, more info might help, but here is and example of a nested if
= IF($L$1>J9,K9-$L$1,IF($L$1>I9,J9-$L$1,IF($L$1>H9,I9-$L$1,H9-$L$1)))
 
Back
Top