+ Reply to Thread
Results 1 to 4 of 4

Creating an IF function in excel 2016

  1. #1
    Registered User
    Join Date
    01-22-2019
    Location
    Morrisville, Pennsylvania
    MS-Off Ver
    MS Office 2016
    Posts
    1

    Creating an IF function in excel 2016

    Alright, so I am trying to do an IF formula in excel 2016 with the following information.
    If B2<=0.393 and B3<=48 it will =0.10
    If B2<=0.393 and B3>48 it will =0.35
    If B2>0.393 and B3>48 it will =0.35
    Everything else will =0

    Can someone please help me? I have tried and tried again and it has not worked.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Creating an IF function in excel 2016

    Untested;
    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: Creating an IF function in excel 2016

    I did test mine in excel and it works

    Please Login or Register  to view this content.

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Creating an IF function in excel 2016

    Please try

    =0.1+OR(B2>0.393,B3>48)*0.25-(B2>0.393)*(B3<=48)*0.35
    Last edited by Bo_Ry; 01-22-2019 at 03:28 AM. Reason: Miss 1 case

+ 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. [SOLVED] VBA function not refreshing Excel 2016
    By maxwelln1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2018, 04:38 AM
  2. Search Function in Excel 2016
    By LSFoster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2018, 08:48 AM
  3. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. 2013 excel to 2016 excel now creating a bug
    By margal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2016, 08:22 PM
  5. Creating new folders and file names using data from sheets in Excel 2016 Mac
    By DylanM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2016, 09:05 AM
  6. Replies: 4
    Last Post: 09-07-2016, 04:52 AM
  7. Ms Excel 2016 IF function
    By tryhyper in forum Excel General
    Replies: 9
    Last Post: 08-13-2016, 08:08 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