+ Reply to Thread
Results 1 to 4 of 4

IF Formula - can you someone pls help a rookie out with this formula?

  1. #1
    Registered User
    Join Date
    12-15-2022
    Location
    vancouver
    MS-Off Ver
    365
    Posts
    4

    IF Formula - can you someone pls help a rookie out with this formula?

    =IF(b5=masterpiece, 100, IF(b5=excellent, 60, IF(b5=outstanding, 40, IF(b5=good, 20, 0))))

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,352

    Re: IF Formula - can you someone pls help a rookie out with this formula?

    Try

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    12-15-2022
    Location
    vancouver
    MS-Off Ver
    365
    Posts
    4

    Re: IF Formula - can you someone pls help a rookie out with this formula?

    ah! that's how you write it out. thank you!
    Last edited by AliGW; 04-13-2024 at 04:19 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,493

    Re: IF Formula - can you someone pls help a rookie out with this formula?

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


    If you finally get a solution please mark your thread as SOLVED:
    - Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
    - you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
    was given. By doing so you can add to the reputation(s) of those who helped.
    Last edited by wk9128; 04-12-2024 at 08:11 PM.

+ 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. Rookie
    By MattMorwood in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-17-2020, 09:46 PM
  2. Replies: 4
    Last Post: 08-25-2015, 07:41 AM
  3. A few formula questions from a rookie
    By matknud in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-16-2015, 05:33 AM
  4. [SOLVED] Formula needed: SUM must never be lower than 19.600 (ROOKIE)
    By NKJAER in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-25-2014, 04:32 AM
  5. i am a rookie
    By kparacha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2007, 12:15 AM
  6. rookie
    By D-- in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2007, 12:49 PM
  7. GST formula - Rookie needs help !
    By Jillian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2007, 07:02 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