excel formula help please (Its easy but I can't see the wood for the trees).

[Raffe]

If you need the outcome to be expressed to 2dp (rather than merely displayed to two dp, for example for further calcs comparisons etc), you’ll need to encase the formula with =round([formula],2)

Nope. Your formula changes the result. If you want it displayed to 2dp, you have to format the cell accordingly.

[Steve27752]

It may as well be hieroglyphs! I have not a clue what you are talking about.

[JGJG]

Nope. Your formula changes the result. If you want it displayed to 2dp, you have to format the cell accordingly.

Yes, that’s exactly what I said - if you want it expressed to two dp rather than merely displayed to two dp

[Raffe]

Yes, that’s exactly what I said - if you want it expressed to two dp rather than merely displayed to two dp

You are correct, I was probably still half asleep when I posted.

[JGJG]

You are correct, I was probably still half asleep when I posted.

No worries :)