| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP NEEDED
I am comparing three prices I want to no the cheapest one could someone
please type in a formula so that I can find the cheapest place. Thank you a b c £4.36 £4.20 £4.51 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP NEEDED
Try
=min(a1:c1) Mike "Merl Wright" wrote: I am comparing three prices I want to no the cheapest one could someone please type in a formula so that I can find the cheapest place. Thank you a b c £4.36 £4.20 £4.51 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP NEEDED
Say prices are in row 2, then enter in D2
=MIN(A2:C2) Regards, Stefi Merl Wright ezt *rta: I am comparing three prices I want to no the cheapest one could someone please type in a formula so that I can find the cheapest place. Thank you a b c £4.36 £4.20 £4.51 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
| Look Up Help Needed Again | Excel Discussion (Misc queries) | |||
| Look Up Help Needed | Excel Discussion (Misc queries) | |||
| help needed | New Users to Excel | |||
| Help Needed? | Excel Discussion (Misc queries) | |||
Hybrid Mode
