A
Alex
I want to go around the maximum of 7 nested functions in Excel. I have
created two named formulas as described on
http://www.cpearson.com/excel/nested.htm
When I use these formulas ('tcvoorw' and 'tcvoorw2') separate they both work
fine. But, when I nest the formulas by using =IF(tcvoorw,tcvoorw,tcvoorw2) it
doesn't. Only the first part of the formula works, in this case tcvoorw. When
I enter a one of the arguments of formula tcvoorw2 the result is an empty
cell.
Ideas, anyone?
Formula tcvoorw:
=IF((Timesheet!E3="U"),50,if((Timesheet!E3="O"),33,IF((Timesheet!E3="PR"),13,IF((Timesheet!E3="T
"),13,IF((Timesheet!E3="A"),33,IF((Timesheet!E3="B"),33,IF((Timesheet!E3="P"),13,IF((Timesheet!E 3="R"),25,""))))))))/60*Timesheet!D3
Formula tcvoorw2:
=IF((Timesheet!E3="Z"),40,IF((Timesheet!E3="Y"),33,IF((Timesheet!E3="X"),13,IF((Timesheet!E3="Q"
),13,IF((Timesheet!E3="W"),33,ALS((Timesheet!E3="F"),33,IF((Timesheet!E3="G"),13,IF((Timesheet!E3 ="H"),40,""))))))))/60*Timesheet!D3
Thanks!
created two named formulas as described on
http://www.cpearson.com/excel/nested.htm
When I use these formulas ('tcvoorw' and 'tcvoorw2') separate they both work
fine. But, when I nest the formulas by using =IF(tcvoorw,tcvoorw,tcvoorw2) it
doesn't. Only the first part of the formula works, in this case tcvoorw. When
I enter a one of the arguments of formula tcvoorw2 the result is an empty
cell.
Ideas, anyone?
Formula tcvoorw:
=IF((Timesheet!E3="U"),50,if((Timesheet!E3="O"),33,IF((Timesheet!E3="PR"),13,IF((Timesheet!E3="T
"),13,IF((Timesheet!E3="A"),33,IF((Timesheet!E3="B"),33,IF((Timesheet!E3="P"),13,IF((Timesheet!E 3="R"),25,""))))))))/60*Timesheet!D3
Formula tcvoorw2:
=IF((Timesheet!E3="Z"),40,IF((Timesheet!E3="Y"),33,IF((Timesheet!E3="X"),13,IF((Timesheet!E3="Q"
),13,IF((Timesheet!E3="W"),33,ALS((Timesheet!E3="F"),33,IF((Timesheet!E3="G"),13,IF((Timesheet!E3 ="H"),40,""))))))))/60*Timesheet!D3
Thanks!