+ Reply to Thread
Results 1 to 2 of 2

Need help with a complicated If Formula

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    Arizona
    MS-Off Ver
    Excel 2003
    Posts
    1

    Need help with a complicated If Formula

    Hello,
    I need to write a couple of multiple variable If formulas and I am struggling and wanted to see if the forum could help.
    First if formula
    If the reference cell is between 98% & 100% than you get 25 points
    If the reference cell is between 97.9% & 95% than you get 10 points
    If the reference cell is below 98% than you get 0 points
    Second if formula
    If the reference cell is between 0 & .19 than you get 50 points
    If the reference cell is between .19 & .24 than you get 25 points
    If the reference cell is .25 or higher than you get 0 points

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,694

    Re: Need help with a complicated If Formula

    Assuming reference cell is A1

    =If(and(A1<=1,A1>.98),25,If(and(A1<.98,A1>=.95),10,0))

    =if(and(A1>0,A1<.2),50,if(and(A1>.19,A1<.25),25,0))
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Formula Help (Probably Not Complicated)
    By Jrm7586 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-28-2013, 12:26 AM
  2. Rather Complicated Formula
    By paulmaddock in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-08-2008, 09:36 AM
  3. complicated if then formula...need help
    By LincAg in forum Excel General
    Replies: 3
    Last Post: 05-25-2006, 01:19 PM
  4. Complicated formula
    By sixwest in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2005, 05:05 PM
  5. [SOLVED] Complicated Formula
    By Stephen in forum Excel General
    Replies: 12
    Last Post: 04-17-2005, 09:06 AM

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