I have a formula -
=ROUNDDOWN((B26/'FA Afford'!G32*12),-2)
which equates to
(£227.14 / 4.85%) * 12
On a standard calculator this gives me roughly '56,199.58762886598' but excel seems to want to round this up automatically to £56,200 in spite of my rounding down.
How can I get this to display as ''56,199.58762886598' and then round down to £56,100.00 ?
=ROUNDDOWN((B26/'FA Afford'!G32*12),-2)
which equates to
(£227.14 / 4.85%) * 12
On a standard calculator this gives me roughly '56,199.58762886598' but excel seems to want to round this up automatically to £56,200 in spite of my rounding down.
How can I get this to display as ''56,199.58762886598' and then round down to £56,100.00 ?