ExcelBanter - Lesser than cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lesser than cell (https://www.excelbanter.com/excel-discussion-misc-queries/199623-lesser-than-cell.html)

Shazza

Lesser than cell

Can someone tell me how you take the figures from two different cells and put
the lesser amount into another cell so that each time they change so does the
main cell
--
Shazzanz

FSt1

Lesser than cell

hi
use the min fuction.
=min(a1,c5,r9,ect)
or
=min(a1:A100)
read up on it in help.

Regards
FSt1

"Shazza" wrote:

Can someone tell me how you take the figures from two different cells and put
the lesser amount into another cell so that each time they change so does the
main cell
--
Shazzanz

All times are GMT +1. The time now is 08:26 AM.