Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1506052%22%20slang%3D%22en-US%22%3EExcel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506052%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22chattext-body%22%3EI%20have%20a%20complex%20formula%20and%20Excel%20is%20setting%20out%20the%20result%20over%20two%20cells%2C%20one%20above%20the%20other.%20I%20have%20never%20seen%20anything%20like%20this%20before.%20The%20formula%20is%20%3DIF(E16%26gt%3B0%2CE16%2F((1%2B%24E%248%2F12)%5E(C16*12)-(1%2B%24E%2410%2F12)%5E(C15%3AC16*2))*(1%2B%24E%248%2F12*1)*(%24E%248%2F12-%24E%2410%2F12)%2C0)%20The%20results%20are%20shown%20in%20two%20cells%3A%20in%20the%20top%20cell%20E17%20is%200.00%20and%20in%20the%20b%20bottom%20cell%20E18%20is%20564.%2C883%20(the%20correct%20answer).%20The%20formula%20itself%20is%20contained%20in%20cell%20E17.%3C%2FP%3E%3CDIV%20class%3D%22chat-footer%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a complex formula and Excel is setting out the result over two cells, one above the other. I have never seen anything like this before. The formula is =IF(E16>0,E16/((1+$E$8/12)^(C16*12)-(1+$E$10/12)^(C15:C16*2))*(1+$E$8/12*1)*($E$8/12-$E$10/12),0) The results are shown in two cells: in the top cell E17 is 0.00 and in the b bottom cell E18 is 564.,883 (the correct answer). The formula itself is contained in cell E17.

 

2 Replies

Hello @RobGlenister

I'm not sure what your actual question is. Additionally a screenshot of the table with some comments added could help to understand the structure and your question.

 

Thank you 

Cheers
Rolf

#MCT #LearnWithRolf #TheCloud42

@Rolf-42 Thanks for getting back to me. I've now gone through the formula again and have made a change which has resolved the problem. Appears I was addressing two cells instead of one in a particular instance.