+ Reply to Thread
Results 1 to 3 of 3

Using =IF correctly?

  1. #1
    Registered User
    Join Date
    05-17-2017
    Location
    Nottingham, England
    MS-Off Ver
    Version 1703
    Posts
    42

    Using =IF correctly?

    Hi all

    I'm trying to create a formula for the following:

    If the number is over 25, then minus 25 off this, however if its below 25, do not minus anything.

    So if its 128, it'll minus 25 off this. However if its 14, it wont?

    I've been told it could be started with ''=IF''

    Thanks in advance!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Using =IF correctly?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Using =IF correctly?

    with the value to be tested in A1 (128 or 14) the if function would look like

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This formula can be in any cell (except A1 where the value to test is stored)

+ 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. Doing ON KEY Correctly
    By Logit in forum Excel General
    Replies: 2
    Last Post: 12-10-2017, 01:10 PM
  2. Not displaying value correctly
    By green369 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2017, 09:43 PM
  3. Not recalculating correctly
    By Steven811 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2012, 06:04 AM
  4. how to correctly use the IF function
    By penfold1992 in forum Excel General
    Replies: 5
    Last Post: 04-11-2012, 09:42 PM
  5. SUM no adding up correctly
    By j_cocker in forum Excel General
    Replies: 8
    Last Post: 01-28-2012, 08:02 PM
  6. CSE Sum-if not working correctly
    By krjohnso in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2009, 05:08 PM
  7. Not Pasting Correctly
    By Larry G. in forum Excel General
    Replies: 3
    Last Post: 07-06-2005, 04:05 PM

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