Hiding cells

[John]

Hello. I have a worksheet in my gradebook where I find
the max number on two different tests and it
automatically puts in the higher number in a specific
cell. What I want to know is how do I hide the cell if
there is no number entered into yet?

This is my formula so far:

In column E:

=MAX(VLOOKUP($C$2,'Master Sheet'!
$A$4:$GA$9919,5,FALSE),VLOOKUP($C$2,'Master Sheet'!
$A$4:$GA$9919,8,FALSE))

Column A is which trimester the test was taken in.

Is there a way that if column A is empty, that column E
will also be left empty?

 

[Bob Phillips]

John,

Try

IF(A1="","",MAX(...))