another simple problem...

L

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
 
M

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
Click to expand...
 
L

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
 
M

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"))))
 
L

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
 
S

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top