J
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?
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?