+ Reply to Thread
Results 1 to 3 of 3

IF Function results

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    Texas
    MS-Off Ver
    Excel 2016, 2019
    Posts
    53

    IF Function results

    Hello all

    What I would like to achieve is if the results in A1 is greater than or equal to 0.25 than it should keep the result from A1*B1. A1 by the way is the sum of other fieldsif function sample.xlsxif function sample.xlsx

    if the results in A1 is less than 0.25 than it should multiple 0.25*B1.

    At a minimum the value of A1 should ever be below 0.25

    Thanks in Advance

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: IF Function results

    Try this... =MAX(A1,0.25)*B1

  3. #3
    Registered User
    Join Date
    09-04-2012
    Location
    Texas
    MS-Off Ver
    Excel 2016, 2019
    Posts
    53

    Re: IF Function results

    djapigo, It works great... Many thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search Function, ROW WISE Results to COLUMN WISE Results
    By juanl in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-27-2013, 04:07 AM
  2. [SOLVED] Unable to display mail merge results using Preview Results function
    By trandle in forum Word Formatting & General
    Replies: 1
    Last Post: 05-30-2012, 12:29 AM
  3. Replies: 2
    Last Post: 03-26-2012, 10:05 AM
  4. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  5. Replies: 3
    Last Post: 03-31-2010, 11:47 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1