Leave cell blank with formula until percentage is typed in

[Benfella]

Good morning guys and greetings from Namibia

After a thorough google search I am still stuck. Please help me.

in column G all the results comes in like 87%, 25% etc.

in column I it shows Pass, Fail

which means if you got 80% and more in column G it will show pass in column I

if you get 79%, it shows Fail in column I

I use this formula;

=IF(G12>79%,"Pass","Fail")

Everything works well except I want to do the following:


since we do not know how many learners we have I want the rows where the formula is to remain blank until a value eg 80% is typed in.

Lets say you have typed in 5 results and there are 5 rows left, that formula in column I must remain but show blank until a value in column G is entered.


Will it be possible?

[BadlySpelledBuoy]

Hi and welcome.

Try this if you type in the percentages manually:
=IF(G12="","",IF(G12>79%,"Pass","Fail"))
Or this if they are calculated:
=IF(G12=0,"",IF(G12>79%,"Pass","Fail"))

BSB

[Benfella]

Thank you very much? It worked u are a genius

[BadlySpelledBuoy]

No problem. Happy to help.

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

BSB