Results 1 to 3 of 3

Thread: Less Than Greater Than Equal To Concatenate With Cell Value For Form If Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-19-2012, 09:08 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    =IF(OR(COUNTIF(D10: D12, "<"&$B$5)>1,COUNTIF(D10: D12,">"&ABS($B$5))>1),"ACTION!","OK")
    Last edited by Admin; 12-19-2012 at 09:17 PM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of The Digits In A Cell Using Formula
    By venkat1926 in forum Excel Help
    Replies: 0
    Last Post: 04-30-2013, 07:11 PM
  2. Count Of Numbers Greater Than Zero In Excel Sheet Using Formula
    By MichielV in forum Excel Help
    Replies: 1
    Last Post: 12-04-2012, 05:30 PM
  3. Color Cell Fill With Conditional Format When Value Less Than Or Greater Than X
    By Oh!Calcutta in forum Excel Help
    Replies: 4
    Last Post: 07-27-2012, 08:43 AM
  4. Passing Parameters Less Than Greater Than Or Equal To Not Equal To
    By PcMax in forum Excel Help
    Replies: 2
    Last Post: 07-15-2012, 04:05 PM
  5. Concatenate Multiple Lookup Values in Single Cell
    By Admin in forum Download Center
    Replies: 4
    Last Post: 04-06-2012, 09:07 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