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.

 

[Skovgaard]

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.

Hi and Welcome to the Forum

Try below:

=IF(ISBLANK([@SCORE]),"",IF([@SCORE]>25,"PASS","FAIL"))

Explanation:
First do the test if it's blank, then test if its above 25.
I removed the test below 25, it doesn't make sense to have both I guess.

/Skovgaard

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF([@SCORE]="","",if([@SCORE]>25,"PASS","FAIL"))

 

[AXILLIAN]

Thank you all for getting back to me.
So I finally got something to work.

=IF([@SCORE]="", "",IF([@SCORE]>25,"PASS",IF([@SCORE]<25,"FAIL",)))

This worked perfect.

Again, thank you.

 

[Fluff]

What should happen if the score is 25?

 

[AXILLIAN]

What should happen if the score is 25?

If the score is over 25 it's a pass or below 25 a fail.

 

[Fluff]

But what if the score IS 25?

 

[AXILLIAN]

But what if the score IS 25?

Sorry, at a loss at what your getting at?

If the score is 25. The percentage cell auto fills the percentage and then it auto fills the pass or fail option!

 

[Fluff]

You are saying it's Pass for OVER 25 & Fail for UNDER 25, what should the cell say if it EQUALS 25?

 

[Peter_SSs]

Sorry, at a loss at what your getting at?

I will try clarifying a different way

A. Here are some scores that are over 25 (>25).
44
25.1
According to your original formula, these are PASS scores

B. Here are some scores that are under 25 (<25).
24.9
18
According to your original formula, these are FAIL scores

C. Here is a score that does not fit in into either A. or B. above.
25

Fluff is trying to determine whether a score like in C. should get a PASS or a FAIL (or something else).
The reason for seeking the clarification is that the formula in post #4, which you currently have marked as the solution, returns zero for this score - see below. I doubt that is the result that you actually want?

AXILLIAN.xlsm
	F		H
1	Score		PASS/FAIL
2	28		PASS
3	55		PASS
4	25		0
5
6	14		FAIL
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=IF([@Score]="", "",IF([@Score]>25,"PASS",IF([@Score]<25,"FAIL",)))