Results 1 to 10 of 10

Using data ranges in an IF statement

Threaded View

ell365 Using data ranges in an IF... 08-27-2007, 08:07 AM
NBVC Try: ... 08-27-2007, 08:13 AM
ell365 damnit 08-27-2007, 08:21 AM
arthurbr Could it be that the formula... 08-27-2007, 08:31 AM
NBVC It works for me... Are you... 08-27-2007, 08:31 AM
ell365 yay! 08-27-2007, 08:39 AM
corinereyes Hello, You are referring... 08-27-2007, 08:39 AM
ell365 no sorry corine, i couldnt... 08-27-2007, 08:49 AM
  1. #1
    Registered User
    Join Date
    08-27-2007
    Posts
    5

    Using data ranges in an IF statement

    hey anyone!

    can anyone help me with my problem?

    I need to be able to give a grade A, B, C or a D by using a range of scores in an IF function for a markbook as part of my IT coursework.

    I have had several failed attempts, and this is one of my many formulas that has failed:

    =IF(O6<45,"D",IF(O6=$46:$60,"C",IF(O6<$61:$74,"B",IF(O6>75,"A"))))

    can anyone tell me what is wrong with it?

    PS. I have attached a screenprint.

    thankyou.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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