Consulting

Results 1 to 4 of 4

Thread: Help with a Formula

  1. 10-31-2017, 12:01 PM #1
    ghostbroker2
    ghostbroker2 is offline
    VBAX Regular
    Joined
    Aug 2017
    Posts
    7
    Location

    Help with a Formula

    I need a formula in cell C2 that says that if cell D3 is greater than or equal to 1.75, it will display the number.
    If it is less than 1.75 it will display "1.75".
    Any help is appreciated.
    Reply With Quote Reply With Quote
  2. 10-31-2017, 12:54 PM #2
    Sandler
    Sandler is offline
    VBAX Regular
    Joined
    May 2016
    Posts
    69
    Location
    =IF(D3>=1.75,D3,1.75)
    Reply With Quote Reply With Quote
  3. 10-31-2017, 01:43 PM #3
    ghostbroker2
    ghostbroker2 is offline
    VBAX Regular
    Joined
    Aug 2017
    Posts
    7
    Location
    Thank you !
    Reply With Quote Reply With Quote
  4. 10-31-2017, 03:30 PM #4
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    Or
    =Max(D3,1.75)
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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