I've just created a nested/embedded logical formula, which appears okay
(i.e., with out errors), and the Function Arguments dialogue box displays an
answer. However, the cell still displays zero and I don't understand why.

If it's of any assistance, I have included the formula below:
=ROUND(IF(AND(G34="Not Applicable",G35="No Allowance Made"),G36,IF(G34="Not
Applicable",G36+G35,IF(G35="No Allowance Made",G36-G34,G36+G35-G34))),0)

I've checked my formatting and this appears okay. Does anyone have any
explanation as to why my result is not displaying?