+ Reply to Thread
Results 1 to 2 of 2

Need perfect RESULT of two cells in another cell with if function

  1. #1
    Registered User
    Join Date
    08-13-2016
    Location
    NAGPUR
    MS-Off Ver
    MS OFFICE 2007
    Posts
    49

    Lightbulb Need perfect RESULT of two cells in another cell with if function

    Sir,

    A B C D
    1 32 08 "Full"
    2 31 08 "Pr"
    3 32 07 "Th"
    4 31 07 " "
    5 AA 08 " "
    6 32 AA " "

    As shown above in the Cell 'C' I need the value that,
    if A1 is greater than or equal to 32 and B1 is greater than or equal to 08, then show C1="Full";
    if A1 is less than 32 and B1 is greater than or equal 08, then show C1="Pr";
    if A1 is greater than or equal to 32 and B1 is less than 08, then show C1="Th";
    if A1 is less than 32 and B1 is less than 08, then show C1=" "
    so also if A1 or B1 cell is contains Text value then result must be shown C1=" "

    PLEASE ASSUME a1 AND b1 CELL AS A EXAMPLE, I SET THE FORMULA IN BG2 AND NEXT CELLS
    Please help me...
    Attached Files Attached Files
    Last edited by vijubhau; 01-04-2018 at 11:47 PM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Need perfect RESULT of two cells in another cell with if function

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

    change references accordingly

+ 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] Need RESULT of two cells in another cell with if function
    By vijubhau in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-02-2018, 10:22 PM
  2. [SOLVED] If the IF function result is false then check the next cell until get a true result
    By Beag air Bheag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2017, 08:55 AM
  3. If Function to get a result based off a range of cells
    By Mgahan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2017, 12:46 AM
  4. Using the Match Function when items are not displayed in a perfect array?
    By larryg003 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2015, 12:25 PM
  5. [SOLVED] VBA: Read cell name and write it on the perfect place in a .txt
    By ropbasuel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 06:33 PM
  6. [SOLVED] A correct IF function doesn't show the function's result in cell
    By Michael in forum Excel General
    Replies: 1
    Last Post: 04-10-2006, 04:15 AM
  7. [SOLVED] How do you make an excel worksheet cell a perfect square
    By charles in forum Excel General
    Replies: 1
    Last Post: 11-10-2005, 12:20 PM

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