if statements

[Guest]

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

 

[Biff]

Can you provide an example?

Biff

 

[Arvi Laanemets]

Hi

=MAX(0,INT(B1/A1))+MAX(0,INT((B1-A1)/5))

 

[Arvi Laanemets]

Sorry


=(B1>A1)+MAX(0,INT((B1-A1)/5))