Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting named formulas
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!E 3 ="H"),40,""))))))))/60*Timesheet!D3 Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting named formulas
How about using a simpler, extendible formula
=LOOKUP(E3,{"A",33;"B",33;"O",33;"PR",13;"R",25;"T ",13;"U",50})/60*TimeSheet!D3 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alex" wrote in message ... 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!E 3 ="H"),40,""))))))))/60*Timesheet!D3 Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting named formulas
That's the answer!!! Thanks!
"Bob Phillips" wrote: How about using a simpler, extendible formula =LOOKUP(E3,{"A",33;"B",33;"O",33;"PR",13;"R",25;"T ",13;"U",50})/60*TimeSheet!D3 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alex" wrote in message ... 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!E 3 ="H"),40,""))))))))/60*Timesheet!D3 Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formulas to show expanded nesting | Excel Discussion (Misc queries) | |||
nesting formulas | Excel Worksheet Functions | |||
Nesting SUMIF formulas | Excel Worksheet Functions | |||
nesting conditional formulas | Excel Worksheet Functions | |||
Nesting Formulas | Excel Worksheet Functions |