Simple spreadsheet maths

[sam_p_lay]

Hello people, what's the formula I'd enter for LibreOffice Calc (or Excel etc) to return the lowest/highest numeric value on a row/column/selection? Thanks

 

[Ijack]

Use the MIN/MAX functions.

 

[bc5]

Thanks ijack! So =min(c5:g5) for example?

 

[Ijack]

Yes, that should do it.

 

[bc5]

Appreciate it