Round the result of a formula to the nearest 0.5

[bazza74]

=IF(F34="","",F34+0.25*(101.3-($F$23*0.133322)))

This is the formaula for N34, but I want it to round the value after conversion (say 49.3) to nearest 0.5 (49.5)

The IF is not necessary if it cannot be done inclusive.

Any help here would be greatly appreciated, I've spent three hrs already.

[ConneXionLost]

If you haven't already done so, install the Analysis Toolpack add-in.
(Tools > Add-Ins...)

Then use the MROUND function.

For your question:

Please Login or Register  to view this content.

[DonkeyOte]

As CXL stipulates MROUND requires activation of ATP on all clients using the file, there is an alternative:

=IF(F34="","",ROUND((F34+0.25*(101.3-($F$23*0.133322)))/0.5,0)*0.5)

Note: for MROUND version you should use the below (typo in CXL's post)

=IF(F34="","",MROUND(F34+0.25*(101.3-($F$23*0.133322)),0.5))

(ie can't round a Null obviously)