Prev: Drop list and redirect
Next: IF Function Help
From: Mikesnhu on 30 Apr 2010 18:15
I am trying to score results
- M4 = test criteria (e.g. 5)
- O4 = test result (blank or a number .001 to 9999)
- P4 = scoring (if the result is blank, retun a blank in P4. if result is
less than test criteria set P4 to 100, else 0)

I need to check for blank and return a blank so that when I total the
scores, I'm not averaging in a zero.

I need to replace this which returns a 0 when O4 is blank:
=IF(O4="",0,IF(O4<=M4,100,0))
This returns an error for using the "" replacing the 0:
=IF(O4="","",IF(O4<=M4,100,0))

Ideas?
From: PatM on 30 Apr 2010 19:02
=IF(ISBLANK(O4),"",IF(O4<=M4,100,0))
should work in cell P4.

"Mikesnhu" wrote:

> I am trying to score results
> - M4 = test criteria (e.g. 5)
> - O4 = test result (blank or a number .001 to 9999)
> - P4 = scoring (if the result is blank, retun a blank in P4. if result is
> less than test criteria set P4 to 100, else 0)
>
> I need to check for blank and return a blank so that when I total the
> scores, I'm not averaging in a zero.
>
> I need to replace this which returns a 0 when O4 is blank:
> =IF(O4="",0,IF(O4<=M4,100,0))
> This returns an error for using the "" replacing the 0:
> =IF(O4="","",IF(O4<=M4,100,0))
>
> Ideas?
 | 
Pages: 1
Prev: Drop list and redirect
Next: IF Function Help