#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Rows With Non-Needed Data between Needed Data Daren Excel Worksheet Functions 2 September 30th 08 06:47 PM
Look Up Help Needed Again Bob Excel Discussion (Misc queries) 3 July 24th 08 03:47 PM
Look Up Help Needed Bob Excel Discussion (Misc queries) 3 July 23rd 08 09:58 PM
help needed predict New Users to Excel 6 September 4th 07 09:39 AM
Help Needed? Nad Excel Discussion (Misc queries) 1 April 24th 07 12:02 PM


All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"