Leave a CELL blank

[AXILLIAN]

Hi all.
OK, so I will try and explain this:

I have a spread sheet for auto working out, Percentage, Then PASS & FAIL. I would like the PASS and FAIL cell to stay blank if nothing is put into the SCORE cell. (Score cell is a drop-down option)

So, when from the SCORE drop down is entered, It auto fills the percentage cell, which then auto enters the PASS or FAIL cell.

This is what I have been advised to use: =IF([@SCORE]>25,"PASS",IF([@SCORE]<25,"FAIL",IFBLANK([@SCORE],””)))

But this does not leave the Pass or Fail cell empty if nothing has been selected in the Score cell!!!

Does this make sense to anyone?

Any help would be greatly apricated.

 

[smozgur]

@AXILLIAN: Welcome to the board!

The post you sent and marked as the solution is a version of the previously provided two functions at post #2 and #3, except it is failing for the score 25 value as explained above. Therefore, to help future readers, I marked post #2 as the solution post since it covers all scenarios and could be easily adapted by using >= operator if the score value 25 is also considered as a PASS.