Hi guys,

I am having some trouble with this formula.

What i need to do is for a simple Pass or Fail to be published if a value is greater that another... easy

=IF(O5 < P5,"Pass", "Fail")
Though, I also need the cell to be blank (" ") if nothing appears in the adjacent L12 column.


=IF((O12 < P12),"Pass", IF((O12 > P12), "Fail",IF((L12=" "),"")))

I cant seem to get this to work.

Any help would be great.