Results 1 to 6 of 6

limiting a returned value?

Threaded View

jb88ci limiting a returned value? 01-31-2011, 02:32 PM
Cutter Re: limiting a returned value? 01-31-2011, 02:37 PM
NBVC Re: limiting a returned value? 01-31-2011, 02:39 PM
jb88ci Re: limiting a returned value? 01-31-2011, 04:21 PM
jb88ci Re: limiting a returned value? 01-31-2011, 04:22 PM
Cutter Re: limiting a returned value? 01-31-2011, 04:26 PM
  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    winnipeg
    MS-Off Ver
    Excel 2003
    Posts
    4

    limiting a returned value?

    I'm having trouble figuring this one out.

    I'm putting together a grades database. We have a policy that if a student gets less than 70% on an exam they can rewrite it. Their final mark will then be the average of the first attempt and second attempt, not to exceed 70%

    In the listed formula, f13 is the first attempt, g13 is the retest. I want H13 to either show f13(if the value is greater than 70) or if F13 is <70% show the average of F13,13 not to exceed 70%.

    It does what i want except limit the displayed average

    =IF(F13<0.7,AVERAGE(F13,G13),F13)

    thanks in advance.
    Last edited by jb88ci; 01-31-2011 at 05:06 PM.

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