We value your privacy. To submit illustration requests on our case design page, please select “Accept All” cookies. If you choose to opt out, we will be unable to receive your illustration requests.
Calculators
Testing some calculators for advisors.
Error:
Unknown formula element: "_xlfn.xlookup"
- Summary.B11=_xlfn.xlookup([.B3];[$RMDs.C4:.C54];[$RMDs.G4:.G54];;-1;1)*[.B5]
- RMDs.D4=IF([.C4]="";"";IF(AND([$Summary.$B$1]>=21916;[.C4]<75);"";_xlfn.xlookup([.$C4];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D5=IF([.C5]="";"";IF(AND([$Summary.$B$1]>=21916;[.C5]<75);"";_xlfn.xlookup([.$C5];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D6=IF([.C6]="";"";IF(AND([$Summary.$B$1]>=21916;[.C6]<75);"";_xlfn.xlookup([.$C6];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D7=IF([.C7]="";"";IF(AND([$Summary.$B$1]>=21916;[.C7]<75);"";_xlfn.xlookup([.$C7];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D8=IF([.C8]="";"";IF(AND([$Summary.$B$1]>=21916;[.C8]<75);"";_xlfn.xlookup([.$C8];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
Demo
