another simple problem...

[London]

I am trying to use the IF function based on a % - which it doesn't seem
to like. Can the cell be formatted as a % if you are using it in an IF
function?

John

 

[Morrigan]

What does Excel not seem to like?

I am trying to use the IF function based on a % - which it doesn't seem
to like. Can the cell be formatted as a % if you are using it in an IF
function?

John

 

[London]

keeps coming up with FALSE

 

[Morrigan]

Can you be more specific what you did?

 

[London]

Pupils attendances

=IF(G6>90,"Excellent",IF(G6>75,"Very
good",IF(G6>60,"Good",IF(G6>50,"Unacceptable"))))

G6 is a percentage - all I wanted to input was the total number of
lessons and the number attended

 

[Morrigan]

Since it's a %, your formula should read

=IF(G6>0.90,"Excellent",IF(G6>0.75,"Very
good",IF(G6>0.60,"Good",IF(G6>0.50,"Unacceptable"))))

 

[Morrigan]

By the way, for 0-50% you will get "FALSE" not "UNACCEPTABLE".

 

[London]

yeah - i just through the amounts in to get it working.
It seems ok until I format the cell as a % then it just returns FALS

 

[Sandy Mann]

London,

What Morrigan is saying to you is that a percentage, (at least under 100%),
is less than 1 so when you format the cell as percentage if divides anything
that you (then) enter into it by 100. He also pointed out that in your
formula there is no provision for the percentage being 50% or less. To
accomodate that make Morrigan's formula something like:

=IF(G6>0.9,"Excellent",IF(G6>0.75,"Very
good",IF(G6>0.6,"Good",IF(G6>0.5,"Could do Better","Unacceptable"))))

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk