advanced IF statment

[qwertyqwerty]

hello,

i was wondering if anyone could tell me how to create an IF statement where i want to compare a a set criteria to a result and give it 1 mark it it makes the criteria and then and extra 1 point for ever 5% it is above the criteria

thanks

[Biff]

Hey, there's a guy named Tom that posted the EXACT same question twice in
another forum!

What a coincidence!

Can you provide an example?

Biff

"qwertyqwerty" <[email protected]>
wrote in message
news:[email protected]...
>
> hello,
>
> i was wondering if anyone could tell me how to create an IF statement
> where i want to compare a a set criteria to a result and give it 1 mark
> it it makes the criteria and then and extra 1 point for ever 5% it is
> above the criteria
>
> thanks
>
>
> --
> qwertyqwerty
> ------------------------------------------------------------------------
> qwertyqwerty's Profile:
> http://www.excelforum.com/member.php...o&userid=28865
> View this thread: http://www.excelforum.com/showthread...hreadid=486145
>

[Roger Govier]

Hi

With your Mark in A1 and your Criteria in B1, try
=--(A1>B1)+INT(((A1-B1)/B1)/0.05)

Regards

Roger Govier


qwertyqwerty wrote:
> hello,
>
> i was wondering if anyone could tell me how to create an IF statement
> where i want to compare a a set criteria to a result and give it 1 mark
> it it makes the criteria and then and extra 1 point for ever 5% it is
> above the criteria
>
> thanks
>
>