I am looking to use a formula in 2 seperate cells that will look at 2 total figures in 2 seperate cells, and return the higher value to both of the cells. so if the 2 cells we are looking at read

£25500 and £22350

I would like the formula to return a value of £25500 in both cells.

I appreciate any help at all.

Many thanks