Formula Help?

[Simon_S]

Please Help,
I have a problem with a simple formula in a Risk
Assessment spreadsheet - 3 Cells namely- G19, H19 & I19.
Cells G & H are (Listed "Probabilty" & "Risk Factor")
respectivly, they are list validated so you can only pick
either "L" Low, "M" Medium & "H" for High.
Now the formula is in cell (Listed "Acceptable") I19,
which is the result from what you choose in cells G & H
and which should answer "YES" or "NO" work ok. Cell I19
can only show "Yes" if both G19 & H19 are both "L" low,
if anything else but "L" the result should be "NO".
But the problem i have is that when the form is blank and
there is no selection in either G19 or H19, Cell I19
still shows "NO" - How can i stop this from
calculating "NO" if cells G19 & H19 are blank?

My Formula is =IF(AND(G19="L",H19="L"),"YES","NO")

It is looking at me in the face but i have been trying to
solve this for a couple of days now!
Please Help!!!!!!!!- Email (e-mail address removed)

 

[Govind]

Hi,

Try this formula in I19

=IF(AND(G19="L",H19="L"),"Yes",IF(AND(G19="",H19=""),"","No"))

Regards

Govind.

 

[Frank Kabel]

Hi
try:
=IF(AND(G19="",H19=""),"",IF(AND(G19="L",H19="L"),"YES","NO"))