Results 1 to 1 of 1

Choose if - struggling and I don't know why.

Threaded View

  1. 10-08-2015, 07:46 AM #1
    holly1212
    holly1212 is offline
    Registered User
    Join Date
    03-05-2015
    Location
    london
    MS-Off Ver
    365 MSO
    Posts
    17

    Choose if - struggling and I don't know why.

    I am struggling with this one and I know it is simple but, I just cannot get it.


    Essentially on the attached, in column H, need it to choose the figure that is greater from Colum B and Column K. What is had was =choose(if(B2<K2,1,if(and(B2>K2),2))),K2,B2)

    I am a bit of an excel novice tbh so this could be way off

    Sorry wrong place and cannot workout how to delete or move
    Attached Files Attached Files
    Last edited by holly1212; 10-08-2015 at 07:54 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Two validations: first choose the sheet (1-5), then choose the option
    By bee88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2014, 08:12 AM
  2. Struggling with IF function
    By Pixelmeastro in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-29-2014, 05:14 AM
  3. [SOLVED] Formula help to choose lowest cost from multiple vendors and then choose vendor
    By roland_arv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-27-2013, 07:48 PM
  4. Struggling with IF
    By KClark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2011, 04:37 AM
  5. struggling
    By Tomas mcD in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 08:25 AM
  6. [SOLVED] Struggling IF value
    By Rebecca in forum Excel General
    Replies: 5
    Last Post: 04-06-2006, 04:55 PM
  7. [SOLVED] Help, I'm Struggling!
    By Fybo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-04-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1