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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks