Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for the LESSER of 2 Calculations | Excel Discussion (Misc queries) | |||
How do I compare two cells and display the lesser of the two cell. | Excel Worksheet Functions | |||
putting a number that is greater or lesser into different cell . | Excel Worksheet Functions | |||
specifying the lesser of two values | Excel Discussion (Misc queries) | |||
if greater or lesser than | Excel Discussion (Misc queries) |