+ Reply to Thread
Results 1 to 2 of 2

Thread: Equation Help

  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Equation Help

    I have gone through the equation a lot and I can't find whats wrong with it.

    =IF(E8>0,IF(H8>0,IF(C8>=$G$3,IF(C8>=$I$3,IF(C8>=$K$3,H8*(($A$3*C8)/E8+($B$3*C8)/E8+($C$3*C8)/E8),H8*(($A$3*C8)/E8+($B$3*C8)/E8)),H8*($A$3*C8)/E8),"Error"),IF(H8<0,IF(C7>=$G$3,IF(C8>=$H$3,IF(C7>=$I$3,IF(C8>=$J$3,IF(C7>=$K$3,IF(C8>=$L$3,H8*(EXP (($A$3*C8)/E8)+EXP(($B$3*C8)/E8)+EXP(($C$3*C8)/E8)),"Error"),H8*(EXP(($A$3*C8)/E8)+EXP(($B$3*C8)/E8))),"Error"),H8*EXP(($A$3*C8)/E8)),"Error"),"Error"),IF(H8=0,0,"Error"))),IF(E8<=0,IF(C7>=$G$3,IF(C8>=$H$3,IF(C7>=$I$3,IF(C8>=$J$3 ,IF(C7>=$K$3,IF(C8>=$L$3,H8*(EXP(($A$3*C8)/E8)+EXP(($B$3*C8)/E8)+EXP(($C$3*C8)/E8)),"Error"),H8*(EXP(($A$3*C8)/E8)+EXP(($B$3*C8)/E8))),"Error"),H8*EXP(($A$3*C8)/E8)),"Error"),"Error"),0))

    If anyone can find it that would be great.

    Thanks

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    5,953

    Re: Equation Help

    Hi Surflbc, welcome to the forum.

    Please take a moment to read the forum rules and then amend your original post's thread title to something descriptive of your problem. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0