Hi all,

Can someone please help me with a problem I'm having using an IF statement
that refers to cells that may have a null value.

I've created a sheet for recording student exam results. Column D shows how
many major errors have been made, Column E shows how many minor errors have
been made, Column F gives a P or F depending on the amount of errors made; 0
major and 4 or less minor are a pass, 1 major or 5 or more minor are a fail.
The formula looks like this;

=IF(D3=1,"F",IF(E34,"F","P"))

and works fine.

However if columns D and E are empty, then I don't want anything displayed in
column F, at the moment all cells in column F are displaying a P. I think
that it may involve more nested IFs for the formula but I seem to be going
around in circles.

Hope someone can help sort this for me,

Thanks,
Tazzy

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200712/1