Forum Discussion

RobGlenister's avatar
RobGlenister
Copper Contributor
Jul 07, 2020

Excel 2016

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...
Rolf-42's avatar
Rolf-42
Iron Contributor
Jul 07, 2020

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

  • RobGlenister's avatar
    RobGlenister
    Copper Contributor
    Jul 07, 2020

    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.