Alternative to excel if nest function

[adinic]

Hello. I have the following problem. In the attached file you will see
part of a program that I have been working on. This part should multipl
columns F and H from workshhet called finisaj with cell g51 from th
first worksheet. The result is copied into the second table and ther
it should be multiplied with the column D from finisaj. And that’
exactly what it’s doing. What I would like to know if there is
different way of doing what I have just told because of the limitation
of the if nesting function. Thank you very much

+-------------------------------------------------------------------
|Filename: work.zip
|Download: http://www.excelforum.com/attachment.php?postid=5245
+-------------------------------------------------------------------

 

[Niek Otten]

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hello. I have the following problem. In the attached file you will see a
| part of a program that I have been working on. This part should multiply
| columns F and H from workshhet called finisaj with cell g51 from the
| first worksheet. The result is copied into the second table and there
| it should be multiplied with the column D from finisaj. And that's
| exactly what it's doing. What I would like to know if there is a
| different way of doing what I have just told because of the limitations
| of the if nesting function. Thank you very much!
|
|
| +-------------------------------------------------------------------+
||Filename: work.zip |
||Download: http://www.excelforum.com/attachment.php?postid=5245 |
| +-------------------------------------------------------------------+
|
| --
| adinic
| ------------------------------------------------------------------------
| adinic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31529
| View this thread: http://www.excelforum.com/showthread.php?threadid=573522
|